• having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 pointsBadges:
  • Download files from a sharepoint site using SSIS.

    Hi, i want to download multiple files from a sharepoint site using SSIS Script task with VB script. I am unable to write script.

    ToWin5 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I import a file to a SQL Server table with dates before 1970?

    I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: 1. Select the max(to_date) + 1 from a table in SQL Server. 2. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • How SSIS works with cluster SQL and non cluster SSIS service?

    According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED. http://msdn2.microsoft.com/en-us/library/ms345193.aspx Now this is the situation that I have where I need to understand how SSIS works? Enviornment: Active Active cluster enviornment for SQL server with SSIS server...

    Munnu5 pointsBadges:
  • SSIS only 255 rows uploaded ?

    Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any suggestions?...

    SbcOrc35 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following