I have a table with three fields, one an identity field, and I need to add some new records from a source that has the other two fields. I'm using SSIS, and I think I should use the merge tool, because one of the sources is not in the local database. But, I'm confused by the merge tool and the proper process. I have my one source (an ...
Using Script Task, I have written a code to create a folder and create a file of msword document inside the created folder. Its working in local machine. But its not working in another server, after I deployed it. The folder is created successfully, but the word document file is not created. for word document creation, I had to refer ano...
I am trying to merge records from an Oracle database table to my local SQL table. I have a variable for the package that is an Object, called OWell. I have a data flow task that gets the Oracle data as a SQL statment (select well_id, well_name from OWell order by Well_ID), and then a conversion task to convert well_id from a DT_STR o...
Can you provide detailed overview of Script Task including Add reference of another assembly with deployment process in the case of referred assembly. ...
Hi I have the following SSIS package: The problem is that within the Foreach loop a connection is opened and closed for each iteration. On running SQL Profiler I see a series of: Audit Login RPC:Completed Audit Logout The duration for the login and the RPC that actually does the work is minimal. However, the duration for the lo...
I have an SSIS package with a Data Flow that takes an ADO.NET data source (just a small table), executes a select * query, and outputs the query results to a flat file (I've also tried just pulling the whole table and not using a SQL select). The problem is that the data source pulls a column that is a Money datatype, and if the value i...
Unfortunately I don't have a repro for my issue, but I thought I would try to describe it in case it sounds familiar to someone... I am using SSIS 2005, SP2. My package has a package-scope user variable - let's call it user_var first step in the control flow is an Execute SQL task which runs a stored procedure. All that SP does is i...
I am new to SSIS. I have a sample .CSV file and i want to transfer the data from .CSV file to SQL DB. So what is the DataSource type for .csv files. I created the Package for excel and load the data to SQL server. please advice me........ Thanks in advance.... ...
I have a SSIS package that I plan to deploy on my SQL Server 2008 machine. I need to call this SSIS package remotely and synchronously from .NET. Obviously I need to pass parameters to this package as well. How could I do that? Thanks, Alex ...
Hi I am trying to generate a CSV file from DB Query as source one of my column is having datatype nvarchar(50) with values as "01050007029604301001" After the export when the csv file is viewed using Excel the value appears as "1.0500E18" . How can i stop this . Please suggest ...
How do we store DataSet object to Dts variable of data type "Object" and store back to another Dataset object, in Script Task ? ...
Is it possible to redirect the Exceptions occurred to another table/log, in Script Task ? If so, How is it to be done ? ...
Given a entry in a sysdtslog90 table in SQL Server 2005 from an SSIS package, how do you figure out what database agent job the entry was run under? ...
Hi I would like to Download Email attachment using SSIS.If possible,Please describe the process. ...
Does anyone know how to Unzip password protected files in an SSIS package? We have an SSIS package that currently use java.util.zip to unzip zip file and has been working perfectly for some time now. They now want to password protect the files and unfortunetly this library cannot do it. We are using a SQL server 2008 with .Net 3.5 on ...
We receive a nightly data export from a vendor in the form of about 10 tab-delimited flat file without column headers. In addition, the vendor provides us with the SQL scripts for the database tables so that we can import the files into our system. Unfortunately, the vendor recently changed the schema for the flat files. Each file has ...
I have about 160 SSIS packages that I'm trying to upgrade from 2005 to 2008. When I run SSISUpgrade.exe on them, I get the following error messages on many of the packages: Error 0xc0209303: ...: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider MICROSOFT.JET.OLEDB.4.0 is not registered -- perhaps no 64...
SSIS performance degrades when using bulk insert task in for each loop to upload multiple files into one target table. how to maintain SSIS performance ...
Is it possible to execute a SSIS package in C# Code ? We can process cube using the namespace "Microsoft.AnalysisServices.AdomdClient". What will be namespace/method to be used for executing a package/task, if possible? This considers Script Task too, in SSIS. ...
Hi, How can I access a 'RecordSet' within a 'Execute SQL' task when using SSIS? I have looked at the parameter mapping options within the Execute SQL Task Editor and cannot find a type of object to allow me to pass the variable holding my record set to the task. ...