I have an application and I want to move some of the tables from the production database to the development database to refresh the data on development. I don't need to move all of the tables. This application is still running on SQL2000 and planned to be upgraded next year. I have SQL2008 installed on my workstation. I was thinking ...
I need to robocopy files from one location to another in a SSIS package. Since the folder is on another domain, I need to impersonate another account before I run the robocopy.exe command. I found I can execute a "net use" command to impersonate the necessary user account and then execute the robocopy command immediately afterwards. I...
I have a centralized table that is populated with row counts and process-level information for every stored procedure on my server. What is the best method for logging rows in a data flow in SSIS and logging start and end times for individual data flows? The only method I have found for logging data flow statistics is to log OnProgress...
I am calling SSIS package from a .Net windows UI. Both SSIS & .Net app are created in 2008. The SSIS package is stored in file system. When I ran .Net app I got error: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no ...
My variable is a string at the package level and have added it as readwritevariable example: public void Main() { string sServer = "localhost"; Dts.Variables["User::sourceServer"].Value = sServer; } will result in Error: The type of the value being assigned to variable differs from the current vari...
I'm mucking about with SSIS and can't figure out how to generate a primary key? I have a very simple SSIS Data Flow: Excel File Source -> Character Map -> ADO.NET Destination The Excel file has the following structure: Field1 The destination table has the following structure: ID - UniqueIdentifier (GUID) Field1 There's no probl...
I am migrating the excel sheet which has different data types using ssis But data format is changing in source level itself My excel sheet looks like below: COL1 Null 1/1/2009 Null 1/2/2009 11.99 123.99 When i see in the source preview it self i am seeing data like COL1 Null 1/1/2009 12:00:00 AM Null 1/2/2009 12:00:00 AM 12/30/18...
SISS 2008 - My package goes green very quickly, but does nothing. The connections are opened, but nothing is being passed in the connection. This problem started when I moved from a test environment to a production one. I'm using package configurations to hold the connection data. ...
I am trying to remove the attribute xmlns="http://webdev2003.test.com" from the following xml using xsl/xslt, a requirement of the XML Task in SSIS. What is a proper methodology considering a large file size. ~40mb <?xml version="1.0" encoding="utf-16"?> <ArrayOfAccount xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="h...
I have to Execute Foreach loop Container in SSIS , for the list of IDs from a table. What I want to do is to get to store the list of IDs in a SSIS variable. I would like to know how to store list of IDs in a int variable. I am curious if anybody has idea about this or any url...? ...
When would you use Integration Services and when would just use SQL/stored procedures? What are the advantages of using one or the other? If you are migrating data from a legacy system, would you use SSIS or just SQL? ...
Within SSIS 2005 I used the Import/Export wizard to create a package that drops/recreates and replaces the data on some tables between my production server and development machine. The control flow that was created by the wizard was extremely complicated so I created a new package and used the "Transfer SQL Server Objects Task" which is ...
Is there a way to map to the same input column to multiple parameters in the OLEDB Command object, or to multiple destination columns in the OLE Destination object? Do I have to make a a copy of the source column with a different name to do this? That seems so...lame. When I need to do an update like this Update MyTable set foo = ? w...
Hi there, Any idea how to join multiple tables in ssis programatically using Merge Join ? I'm using c#. thanks, Jibin ...
I have a relatively big SSIS package which I'm trying to edit. I basically need to update a query on an Execute SQL Task. Problem is the solution is not saving the query when I do the change. I open the SQL Task, change the query and close the task. I verify the change before saving and it's there but as soon as I click on the save butto...
Is it possible to uppercase the first character of each word using regex? I'm going to be using this in VB.net (SSIS) ...
I'm looking for a good tool to document SSIS workflows. Best would be if its not only text based documentation, some visual overview of what happens in the SSIS package would be nice. ...
I've managed to connect my SQL Server 2005 in Windows 64 bit server with ORACLE database. (Thanks to Mr. Jeyong Park :http://knol.google.com/k/jeyong-park/accessing-oracle-data-source-from-64bit/3vywlm4f31xae/12) The problem is : In SSIS when I used Oracle as a OLE DB Data Source and previewed the data, it works, however, when I run the...
Is there any built in way to read a file with SSIS and after reading it clearing the file of all content? ...
Hi, This is a SQL Server Integration Services (SSIS) expressions question (I'm pretty new to it). I would like to write a switch/case expression in a Derived Column transform - basically the new column can have 5 different possible values, based on the value of an input column. All I got from Google is the (condition) ? (true value) ...