If there's an SQL 2005 admin around, I'd appreciate an interpretation on the below error. I'm trying to deploy an SSIS package to a shared SQL 2005 host. They claim they allow installations of such packages, but it appears to me they do not have permissions setup correctly. - - - - - - - - ...more >>

I have a data flow that I am preparing, where I am getting a list of values from a Ole DB datasource, and then I want to query a second ODBC datasource witht those values. This ODBC datasource requires a "WHERE" clause containing the data I got from the other database (so select * and then ...more >>

Hello everyone I have an SQL Server 2005 SSIS Package which users can initiate using when the use my IIS website. I kick the package off from code in a separate thread. It is used to import data and it makes repeated calls to the Look Up transformation to validate. If two or more instanc...more >>

Hi there, where can I view what SSIS packages are installed on a server? ...more >>

When a step in my DTS Package fails, it would be nice if the actual DTS error could be e-mailed. Is this possible? How would I go about doing this? Thanks, Rog ...more >>

Does anyone know why when launching a package containing a child package from a SQL Server Agent job, the parent package launches correctly but the child package does not? Any help or direction is greatly appreciated. ...more >>

First, let me quickly say that, so far, this is the best, most concentrated site I have found with worthwhile information concerning SSIS. Kudos to all who have contributed. My questions: I'm still trying to get up to speed with SSIS. (I liked DTS, cautious of SSIS) In my situation, I have...more >>

I have a client that is getting the error "Unable to prepare the SSIS bulk insert for data insertion". The Sql Server is the same server as the SSIS package and I have changed my connection type from SQL Server to OLE DB with still get the error.. Both myself and my client are System Admins...more >>

Hi there, I have SQL 2005 Express and cannot find SSIS. I can save a package from the Import Export wizard, but cannot see anywhere where you can view or design packages. I have even downloaded DTS for 2005 from Microsoft, but still cannot find a way of designing packages. Do...more >>

I have access to a shared SQL 2005 server. So far, I cannot save my first SSIS package due to an execute permisison error. I'm assuming it's a rights issue and will get resolved. In the interim, I'm trying to get up to speed with the differences between DTS and SSIS. In DTS, I used the wiza...more >>

There is a master package with several child packages. The encryption i have is EncryptSensitiveWithPassword. Is there a way i can set the password dynamically using configuration file or parent variable . I see no option to do it. Please advise . thank you !...more >>

Hello, I have a package that calls another package using the "Execute Package Task". When I execute the parent package from BIDS or designer, the parent package calls the child package without a problem. If I execute the package from a SQL Server Agent job, the child package does not execut...more >>

Hi, I have a folder located in C:\test. In the folder, there are lot of text file and word document. Is there a way I can create a file system task to delete the text file only? Thanks,...more >>