Hi I am getting below error in ssis package. Package contains Transfer SQL Server Object Task which Replace Data in destination table. I have source dimension table from which I am replacing data in destination dimension table.There is no FK constraint present on source & destination dimension table which may not allow truncate table. ...
I am using OLE DB data source component as a part of data flow task, but I would like to keep the sql query in an external file and not embedded in the task itself. Is there an easy way to accomplish this? ...
I have many SSIS packages that all connect to the same database. I don't want to hard code the server name into the db connection in each database, because it is different from the dev to live server. And those server names might change over time. I know that you can put it in a config file, but all these SSIS packages are stored in SQL...
I'd like to use the Bulk Insert Task using a format file to a target Server/Database/Table. The table may or may not already exist. Is there anyway to have the Bulk Insert Task in SSIS 2008 drop and re-create the table from my SSIS Format File as part of the process? ...
Say I have a text file that looks like this: date 1/1/2010 a,b,c a,b,d ... I want to import it into a table so it looks like this: 1/1/2010,a,b,c 1/1/2010,a,b,d ... What is an elegant way to do that? My best idea so far is to use a data flow package, and use a flat file source to read in the file (ignoring the first line) and lo...
Anybody know vendor for fast upsert components in SSIS So far I found one from Pragmaticworks - TaskFactory - SSIS Tasks and components I was very impressed with Upsert, Data Clenasing, SFTP and Zip (Much faster than any other solution out there) ...
We have several SSIS packages and want to audit the follwoing items Package runtime Errors, Warnings Extracted/Loaded Row count Source and destination Filename, SQL Query, table name Package and Task Performance So far I found only one tool from Pargmaticworks BI xPress - Audit, Notify, Deploy SSIS Anyone used this before... all featu...
Hello All, When I use ADO.net source in DataFlow to read Blob Column and pass it to Script Component to do further validations - need script compoment to do further validations on each column to generate master / child error records master (for each row) and child (for each error column). This works fine. As I need to parameterize my ...
Hello, I am using SQL Server 2008 SSIS for importing data to the DB and .Net 3.5 SP1 for Creating the WCF service. In the import task I am trying to use the Web Service Task to report to a WCF service. At first I encountered a problem with the WCF WSDL, the Web Service task couldn't get their code generated from the metadata exposed by...
Hi there, This is my first question so bear with me, i will also attempt to answer one somewhere if i can as payment, though not sure my skills are up to it yet. I have a stored procedure in SQL 2008 that at the moment executes with a result of about 600 odd rows, it has unions within it and a user defined function used multiple times....
I have got a SSIS Package running every 2 hours. It collects data from different DBs and updates the DB of my ASP.Net Application. Everything goes smooth, but the asp.net application is still using the old data, it has the data somehow cached. If I just open save the web.config, it empties the cache and uses the updated new data. How ca...
I'm trying to create a mining model for forecasting against some DW data. I'm using SSIS for my ETL, and trying to use the Data Mining Model Training destination. Unfortunately I'm receiving an error whenever the column I'm trying to predict is numeric or decimal format. I don't get the error when I create the model by hand in SSMS, a...
I need a good overview book on SQL server 2005. I'm trying to move from SQL server 2000/DTS to SQL server 2005/SSIS. I've searched around on safari and most books seem to be about a specific part of SQL Server 2005 or a particular principle. I'm wondering if anyone can specifically recommend a solid book that covers the following areas ...
I have a small solution that i provide to several people. The solution consists of amongst other things an existing SsisPackage (default.dtsx). I modify this according to some settings in my application to prepare it for transfering data from a datasource to a datamart. I add a sequence container, add a foreachloop and add a dadtaflowtas...
I am importing SSIS packages to SQL Server 2008 that were originally built for SQL Server 2005. I upgraded them in VS2008 and them imported them. They all import and work except for the one with the Konesans File system Watcher task. I installed in the setup exe for Konesans File system Watcher SQL Server 2008 on my dev pc and the produ...
I got a script component which does Transformation / DataType conversions / Creating some calculated columns. All the transform validations / datatype conversion methods and for new column generation is put into custom .dll. As this script component would be same for all other tables, only thing is to define input / ouput columns and a...
The way I understand it, SSIS script tasks can't use a reference unless it's in the GAC. With this assumption: I've tried downloading the .net 2.0 sdk x64 (developing on 64 bit machine) that should have gacutil, still not there. I've tried installing the dll using a console app using the System.EnterpriseServices.Internal.Publish.Ga...
What is the best way to read system variables from Script Component. Tried as below: Works fine when is User variable base.PreExecute(); IDTSVariables100 variables = null; VariableDispenser.LockForRead("System::ContainerStartTime"); VariableDispenser.GetVariables(out variables); auditTimeStamp = Convert.ToDateTime(v...
HI All, I have a SSIS package which Imports data from Excel to database.I added this package to execute as a SQL Agent Job.When I am running the package as a job I am able to run it successfully.When I run the package from Visual Studio I am getting error saying... "Code:0xC0202009 Source:User Connection manager " Excel Connection mana...
Hi, I'm a newbie to SSIS / C# (I'm generally a Java developer) so apologies if this is a really stupid question. Essentially the problem is this: I have two Data Flow tasks which load data up and export them to a legacy flat file format. The formatting is done by a Script Task (C#). What I'd like to do is share some common code between...