Hey all, Im looking to Extract a SharePoint List (WSS 2.0) to a SQL(2005) Table using SQL Server Integrated Services. First off I am aware of the "adapter" that does this from http://msdn.microsoft.com/en-us/library/dd365137.aspx however I'm just wondering for compatibility purposes if it can't just be done "out of the box". There are...
I get an "Index was outside the bounds of the array." error when I do the following. 1) I launch the Import and Export Data Wizard (32 bit). 2) Data source: .Net Framework Data Provider for Odbc. 3) I provide a connection string and DSN for a 32 bit Progress OpenEdge 10.2A ODBC driver that I've set up. 4) I set up a flat file destina...
I am using SSIS to copy data from a table in Oracle to a table in SQL Server 2005. There's no transformation required, so it's just a straight line connecting OLE DB Source to OLE DB Destination. Fairly simple and works, but during execution, a record in the Oracle table contains a timestamp value of the year 0002 in encountered, so SS...
SSIS Team Blog has written a good article titled "API Sample - OleDB source and OleDB destination", showing how to programmatically create a data flow that reads from OleDB source and writes to a different Ole DB destination table. http://blogs.msdn.com/mattm/archive/2008/12/30/api-sample-oledb-source-and-oledb-destination.aspx The pro...
I am doing an SSIS look up transformation, looking up in a voyages table, however some of my records don't have voyages, so I get errors. Is there any way that I can skip the look up on those records. ...
Hi everyone, I'm using SSIS on SQL Server 2005 and have run across an error. As part of the cleanup process I removed a couple of connections from the connection manager section, that we didn't end up using. But now when I attempt to execute the package I get an error stating that "The connection {some guid} is not found. This error ...
DB: SQL Server 2005 We have a table that has data in this manner: Project Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov ...
I find that I regularly need to track a value through an SSIS Data Flow. The process that I use to do this is manual and time consuming. Are there any techniques or tools that I can use to reduce the effort (and potential for error)? What I really need is a means of quickly identifying the data flow components that modify the values in ...
I'm new to T-SQL; all my experience is in a completely different database environment (Openedge). I've learned enough to write the procedure below -- but also enough to know that I don't know enough! This routine will have to go into a live environment soon, and it works, but I'm quite certain there are a number of c**k-ups and gotch...
I need to escape quotation marks in SQL Server Integration Services' Expression Builder. I cannot escape it with double or triple quotes. ...
Obviously I am wrong in saying that DDD is similar to EAV/CR in usefulness, but the only difference I see so far is physical tables build for each entity with lots of joins rather than three tables and lots of joins. This must be due to my lack of DDD understanding. How do you physically store these objects to the database without sign...
I am currently working on a SSIS package that is extracting a table from one database to another. The tables in both of the databases use the same column as the primary key. My select statement to extract the data is a simple select statement. When I ran the package I was receiving a error that there where duplicate primary key values...
What would be the best method to use for testing that connection managers are correctly pulling their connection strings from the package configurations on multiple packages (In VS 2008). In the past I have created a data flow which ran the query select @@servername and outputed to a text file. While this works, it seems a bit redundan...
Am trying to execute sql from script component, but getting error when trying to establish SQL connection. My Code below in Script Component under PreExecute() base.PreExecute(); variables = null; VariableDispenser.LockForWrite("User::TableName"); VariableDispenser.LockForWrite("User::SqlConnectionString"); VariableDisp...
I have am OLEDB Connection configured in the connection managers and I want to use it in a SCRIPT. The script needs to call a stored proc and then create buffer rows. I have added the connection to the connections available to the script and this is my code. Boolean fireagain = true; SqlConnection conn = new SqlConnection(); conn = (S...
This is with SQL 2005. I have a script component inside a Data Flow Task. I would like to read from the input columns and write the data to a global user variable. I've set my input columns and added my global user variable as a ReadWriteVariable to the script component properties. Here is my code, I'm just trying to alter the value ...
I'm using message queue task in SSIS to receive message from a private queue, I set MessageType To "String message to variable" and Compare to "None" When I debug on this package, it's stuck at message queue task, I've checked the private msmq, there are some messages in it. Any ideas/Help? Thanks ...
I am creating a ETL process in MS SQL Server and I would like to have errors specific to a particular column of a particular row. For example, the data is initially loaded from excel files into a table(we'll call the Initial table) where all columns are varchar(2000) and then I stage the data to another table(the DataTypedTable) that co...
Hi What are the best resources free download(websites/webservice) to get/read foreign exchange(currency convertion) information directly to my application. data can be excel,.axf,csv,xml. I would like to know the possibility of reading from direct website/webservice to ssis components as well Thanks, ...
In SSIS 2005, in a OLE DB Destination Editor, on the Error Output page, the Error column allows me to make a selection, but the Truncation column is greyed out. I want to be able to setup a path such that I can log truncations of strings when inserted into the destination table. Why is the Truncation option greyed out? ...