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 >>

My DTS package runs fine when I execute it (from Enterprise Manager) and I can open the scheduling option by right-clicking the DTS package, but it won't save the schedule I create. Any ideas?? ...more >>

I went through the Migration Wizard. Management -> Legacy -> Right click on Data Transformation Services. I just want to migrate a simple DTS package that copies objects from one database to another. When I run through the wizard, it runs successful; however when I go to Management -> Legac...more >>

Hi I have a problem regarding running a SSIS Package in a schedule Job (SQL server agent). I recently moved all my SQL server 2005 components (SQL server, SSIS, SSRS) to a new SQL server 2005 with service pack 2 installed. I also created a new job to run my old packages. When I’m running ...more >>

Hi I'm currently experiencing the following error when running one of my packages: Error: 2007-08-27 13:52:43.91 Code: 0xC0202009 Source: ************* Connection manager "Excel Connection Manager" Description: An OLE DB error has occurred. Error code: 0x80040154. An OLE DB reco...more >>

Hello to everyone. I need to synchronize data between servers, where the source is SQL Server Express 2005, and the the server is SQL Server 2000. I´m using VB.NET, and I linked the server, and then pass the information to the server, but here is my problem: TABLE CUSTOMERS ID CUSTOMER...more >>

Hi, I'd like to filter data in the OLE DB Source node based on a variable value, to realize the function simliar to "SELECT * FROM Table WHERE Col1=@var1". But it appears to me that the only way I can do this is manually structure a sql statement in a Script Task node and execute it in the ...more >>

I'm relatively new to SSIS and am getting frustrated. I have a simple Execute SQL Task that is getting an "Invalid character value for cast specification" error. Here's the issue (all names are changed to simplify). I have a stored procedure with three parameters: dbo.someproc ( @p1 int...more >>

I have to write a SSIS package to transfer data from production server which has about 120 databases to dev server. Each database has 160 tables and each table I only need a few columns out of it. Has anyone had done a similar project like this or know of a best way to do it. The trick for ...more >>

Hi, I have created a SSIS package and the protection level was set to "EncryptSensitiveWithUserKey". I'd like to change it to "ServerStorage". But when I try to save the package, I got the following error: Failure saving package. ------------------------------ ADDITIONAL INFORMATION: ...more >>

The good thing is we don't have to parse the raw EDI, we are getting the data from a service that gives it to as us CSV files. The bad thing is, within a single CSV file it's still hierarchical, so we get data like: head, a, v1, v2,,,,, line, a, 1, v1, v2,,,, comment, a, 1, t1,,,,, line,...more >>

Hi, When I attempt to create a new Integrations Project I receive words to the effect 'project integration creation failed'. Under Vista, I have un-installed SQL Server 2005 and reapplied SP2 and Vista fix. Same results. Any suggestions? ...more >>

Hi I'm trying to copy a table across from a Sybase ASE server to MSSQL Server. I'm not doing any transformation logic on the data, I just want to copy the table across. The package runs ok, but I found that a particular field is missing a digit when it comes across. The datatype is money...more >>

I am an Oracle DBA. I want to learn SQL SERVER 2000 in depth (i.e. become an expert SQL SERVER DBA). Can you point any artciles/books which show mapping of terminologies from Oracle to SQL Server. I know there are some artciles on Microsoft's web site, but looking for other artcles as well. ...more >>

Hi: ...more >>

Hi: I have a task that I need to retrive data from a table in teradata database every month. However, the name of the table change every month depends on the month. For example, in Jul 07, it will be table_200707 and table-2007_08 in Aug 08. ...more >>

hi! I have 2 questions about SSIS. 1. In my SSIS project there are many dtsx can I arrange them into different folder? like SSIS_PROJ | ---FolerA---DTSX1, DTSX2,DTSX3 ---FolerB---DTSX4, DTSX5,DTSX6 I've tried to arrange these DTSX but failed. I wonder if there is something like SSRS ...more >>

Hi everyone, I'm asked to continue an existing project in SSIS, which currently uses XML for logging. I noticed that we now have log files up to 200MB in size. Is there a way to limit those log files in size? Please do keep in mind that I'm still learning SSIS, so keep your answer as ...more >>

Hi, I am having a problem with a DTS in which I run SQL statements choosing different connections. I have added a new Production server and I created a new connection for that. Now whenever I try to run the step using the new connection I get this error: [DBNETLIB][ConnectionOpen (Connec...more >>

I have a sql server sp4 that has about 910 DTS packages with package logging. I'm not certain if all the packages have package logging but many do. The issue we are having is that these logs are beginnning to fill up the msdb database. Is there a way to schedule a package, run a script,or is ...more >>

I am using SQL2005 management studio to export the data from a table to a flat file. If I include a text delimiter it adds it to every column, i have checked the columns with the edit transforms button and some of them are ints. Is there a setting that I am missing that needs to be enabled s...more >>

I want to write the following condition in where clause SELECT * FROM Cust_Data WHERE Cust_ID IN (CASE WHEN Cust_No = 345 THEN 12,23,34 ELSE 56,67 END) but i know syntactically it is in correct. I also tried it this way WHERE Cust_ID IN (CASE WHEN Cust_No = 345 THEN (select ID From Cus...more >>

Hi. If I right-click a SQL 2000 dts package and select Schedule, and then specify a schedule of every one (1) hour and click ok, the next time I open the Schedule window that setting is removed. When I reopen the Schedule window the default setting of 'once a day at 12:00AM' is selected. ...more >>

Hi All, I have searched the newsgroup and web for something that would answer this problem but I haven't been able to find anything... I have created an SSIS package using the "Import Data..." wizard to transfer data from one database on the server to another on the same server. I am sa...more >>

DTS makes it simple enough to import a text file from the local PC (e.g., C:\MyFolder\MyData.csv) when running Enterprise Manager, but how, exactly (step-by-step), do I go about getting that same text file from a location other than the local PC using a scheduled DTS package? Here are two scena...more >>

Just looking (for the first time!) at the SSIS docs, they seem to emphasize using integrated security if/when saving package to msdb. Any idea why? http://msdn2.microsoft.com/en-us/library/ms186803.aspx So happens my current shop is not much on integrated security. J. ...more >>

I'm having trouble passing package level variables into my script transformation. I'm fine as long as I pass only one variable in but as soon as I list two variables I get the error "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variabl...more >>

I have SSIS(DTS) using the dataflow OLE db which query the database to extract information for actions done yestarday. In the sql statement i'm using calling the function DATEADD(dd, -1, getdate()) to extract the yestardays information on a date field. This package sends information in excel for...more >>

newbie question: One step of a DTS package calls a stored procedure that does a query that builds a table. (i.e. exec procedure name) next I want to run an update on the table after the stored procedure is finished. Whats best? 1. put the update sql in the same step after the stored procedure...more >>

Hi, Can someone please let me know the size of data type - "String" in SSIS package? I tried to search for it but the documentation gives me the details of data types DT_STR/DT_WSTR which are actually not available in SSIS package. Thanks in advance. Gayatri Kulkarni ...more >>

Hello, I have about 55 clients for which I need to process data. There will be as many as 5 steps to move data from one database to the other, transform the data and then final processing of the data. Question 1: Can I execute multiple SQL Tasks at the same time? I would need to start...more >>

I am getting the following error when I try to run the DTS package that was is to be run as a scheduled job: DTSStep_DTSActiveScriptTask_2 DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime e...more >>

The idea is to make the connectionstring property of the oledb connection dynamic (Which is in connection manager). Using the wizard, created a package configuration file called Configurations.dtsConfig Opened it in notepad and placed the connectionstring inside <ConfiguredValue></Config...more >>

Hi, SSIS packages are now created and tested against dev sql server. Now I would like them all to point to the live sql server. What is the best way to have the connection dynamic? Obviously I prefer not to go through each package and change the connection manager. Thanks...more >>

is it possible to import data from Excel 2007 (.xlsx files) into SQL Server from SSIS? The Excel Source only gives up Excel 97-2005 (plus the old versions 3/4/5) ...more >>

MS and DB gurus, I have this scenario. Source of Data: Paradox Data using ODBC / Paradox Drivers I need to send DYNAMICALLY built Queries to Paradox and grab the data. Save the data to the SQL Server table. The dynamic query building will happen in the Web Front end using ASP.net page...more >>

Hi, How do I prevent permission wiped from my SPs when it comes to restoring dbs? Is there a way to assign permission globally? Thanks. -- bic...more >>

Hi, does anyone have an opinion as to where packages should be saved? I am using the file system at the moment but I've read that it's more secure and reliable if saved in msdb. I don't have a problem with the file system but we have a problem with Doubletake (software for DR) and I am hopi...more >>