I'm exporting an MSAccess table to a flat file using a simple Data Flow Task in VStudio SSIS. My problem is a column, defined in the table as Number(Double) is being forced to scientific notation, no matter what data type I select in the destination flat file connection manager. Is there someplace else to determine the source data type?...
I have a tab delimited file on a shared path. I've setup that flat file as a connection in an SSIS package. I'd like my package to verify the existence of the file before I try to do transformations and import it into a database table. I'm new at this, and I'm replacing a script that checks the existence of the file by hard-coding the...
Can anyone provide details on what the three of these mean? System::ContainerStartTime System::CreationDate System::StartTime The documentation for these three is virtually non-existent. ...
I need call a ActiveX in my SSIS package, so I use script task and write the following C# script: public void Main() { clsAptFdbReader objFdbReader = new clsAptFdbReader("UnitedStates20000830.fdb"); objFdbReader.OpenFdb(false); Dts.TaskResult = (int)ScriptResults.Success; } Get a error: Error: System.Reflection.Targe...
If I open the script and set a breakpoint, it is ignored. In fact, if I close and re-open the script, the breakpoint is no longer there. Even "Stop" commands do not cause it to break. If I put a break point on the containing Data Flow Task in the Control Flow diagram, it stops, but when I try to step into it, I get the error messa...
When I execute a sql statement like "Select ...", I can only see "...100%" completed... I want to log the number of rows affected. How can we do that? ...
I am using 64-bit Vista and I need to migrate an access database, in Office 2007 to SQL Server. I don't want to have to write an SSIS package to do this, but that may be my only option. Is there any other way to do this? I have about 330M of data in Access that needs to be moved, so I can write a webapp to replace this database. Updat...
Here is a situation, There is SERVER A and SERVER B, SERVER B wants to restore backup taken by SERVER A on its own local machine now I know I have a little bigger way to setup FTP etc to transfer the FILE but I want to know that can I write a SSIS Package which would do file transfer from SERVER A to SERVER B without depending upon FTP/...
I am planning to migrate a large database table from our main SQL database to a separate one. Because it's a high volume/one time process, I'm going to use SSIS. Does anyone know how best to time migrating all the data and changing the code's connection string? Quick background: Our system uses a table to log every notification that i...
I have an SSIS project where one of the steps involves populating a SQL Server table from an Oracle Table. The Oracle table has a column ssis_control_flag. I want to pull across all records that have this field set to 'T'. Now, I was wondering which would be the best way of doing this, and the two options as I have detailed in the qu...
Input : Pairs of From->To Rows. From To 1 2 2 3 3 4 6 7 Output: For Each From Value, pairs of reachable To values. E.g. for 1 Source Reachable 1 2 1 3 1 4 Obviously, one can suck out the data to a Graph structure and run DFS scan. Is there a alternative way to do so, such that: Uses SQL/Fu...
Hi, I am having a stored proc which return 2 records and which contains a select statement from a temp table, So when i used this stored proc inside a OLEDB Source in SSIS and just trying to insert the set of records into a destination SQL table using OLEDB destination. Its throwing a ERROR at source side saying : [OLE DB Source [166...
I have rewritten an old program and designed a new database for it. I need to transfer the old data to the new database. The new database has a new schema, so I will have to manipulate much of the data that is going to be transfered. I have thought about writing a console app with 2 linq to sql contexts, one for each database and coding...
Using SQL Server 2005, but still using DTS. I need to add a step to check if a table is empty, and somehow fail the step if it is. It's easy checking if the table is empty: Select count(*) from source_table But returning 0 is a success, too. If it is 0, I want a failure (so that I can fork to a different option, email us, skip some...
Hello, I have a number of SSIS packages that are launched by Windows Services. These packages point to any number of different databases, and the connection information is known only by the service at run-time. I know that I can't save connection strings inside the package, but it seems that I can't even pass in a complete "connection...
We have been running an SSIS package successfully in production now for 3 weeks, after 2 months of extensive testing. Last night the package failed repeatedly with the error message : "Not enough storage is available to complete this operation" On one occasion it failed with message : "A buffer failed while allocating 10483456 bytes....
I have an SQL 2005 SSIS package that takes data from an Oracle DB Table, and transfers it to a SQL Server Table. I have set up an "Oracle Provider for OLE DB" for the Oracle connection and a "SQL Native Client" for SQL Server Connection. The Oracle and SQL connections will depend on the development and shipping stage, which are: Loca...
I'm planning to use XML configuration files to run SSIS jobs on both development and production servers. I'll be using the SQL Server to store the SSIS packages. I'm wondering if there's a standard place to store the XML files. There's no need to create a project folder for the packages since they'll be stored in the database. So is ...
In VB pseudocode, I'm trying to accomplish the following using SSIS (either 2008 or 2005) If FileHasAlreadyBeenDownloaded = False Then DownloadTheFileFromFTP End If ImportTheDownloadedFile To do this in SSIS I have a script task to check for the file, and if it exists it transfers directly to the DataFlow Task using conditional exp...
We're essentially bulk loading data from one database to another, using SSIS. My co-worker has made one data transform object, and within it, he has a transform for each table. I've made a transform object for each table. We're both rather new to SSIS. Is one way better than the other? What are advantages or disadvantages to each me...