View Complete Post
I have BI Server and Tables and Data Populated using SSIS package.Now Data is ready in BI server.Next week Ihave to same excersize to filll the Data(DROP tables,CREATE table and Pump the Data)
Can any body give an idea how to create SSIS package which can pupm the Delta Data Oracle and SQL Server.
Thanks in advance
For a DataWareHouse project, I did an WIX install manager to Create à DataWareHouse, Deploy SSIS package and Deploy a OLAP cube.
When It come to deploy (load) dtsx package, it takes about 40-60 secondes to load each package (I have around 50 packages so its really too long)
This is the code i'm using :
DirectoryInfo di = new DirectoryInfo(session["INSTALLLOCATION"] + @"Sources");
FileInfo rgFiles = di.GetFiles("*.dtsx");
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
foreach (FileInfo fi in rgFiles)
string pkg = session["INSTALLLOCATION"] + @"Sources\" + fi.Name + "";
Package p = app.LoadPackage(pkg, null); //THIS TAKE 40-60 SECONDE TO EXECUTE
In my project, i have two data sources tables lets say oledb1 and oledb 2 in data flow task.
i want to load the data into destination (oledb3) by using the following logic...
select col1, col2, col3 from oledb1 where col1 not in (select col1 from oledb2);
Please help me...
How do I join a SSIS text field type cast from the Derived Column Transformation Editor with a varchar from an SQL data table in a lookup?
Also, is there any reference on which SSIS data flow datatypes can be JOINed to SQL Server datatypes?
Here's the problem: I have records in a flat file. The flat file name contains the data of the records. When importing, I read the flat file name into a data field using SSIS. Then, I use FINDSTRING to create a derived column that
contains just the file date as YYYYMMDD.
There's a SQL Table that contains Currency Rates, indexed by currency code and date, in DD/MM/YYYY format, but it's stored as a VARCHAR
A.) I tried to convert the string, '07302010' into the following formats, without success:
However, none of these can understand the string '20100730' as a date!
B.) Furthermore, if i convert the field into a DTW_STR, it still doesn't match the varchar(50) in my db.
So, basically, despite using all available typecast date formats, and several string formats as well, I can't find a way to
A.) Parse text out of a field
B.) Convert that text to either a DATE format or a TEXT format
C.) Use that resulting field to
I have created one package to archive database. The target database is around 400 GB data and source db is around 300 GB. I have the Lookup control to check the duplicates in the data. The package is working fine with small amount of data. but it is giving the errors when I am trying to archive some 400 GB of data. Getting the below errors while running the package
1)Communication link failure2)TCP Provider: An existing connection was forcibly closed by the remote host3)OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties4)failed the pre-execute phase and returned error code 0xC020824E.
Appreciating your help in advanceThanks,Loknath
I made a installer program in C# that deploy ssis package on a SQL server 2005. I have like 50 package that contain only dataflow to update a datawarehouse and create fact tables.
I made also one package that call all the other packages. When I try to deploy the packages on the SQL server with the command SaveToDtsServer, I receive an error
BUT only on the package calling all the other SSIS package ??
All the other SSIS packages are deployed but the package that call other packages failed to deploy. Whats strange is that when I use the domain controler to deploy the package (I use Impersonation in my C# code)
its all working fine, but if I use another user (like the computer admin account), I got the error only on the package calling other packages ???
Can anyone help me on that ? I really don't know whats happening ?
The error that i have is : The file can't be found. But like I said, when using the domain controler user for impersonation, its working ???
imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);
Hello Every One,
I have a scenario in which i am executing a Stored Procedure which returned a result set.
I want to create a Excel file [name_date_time] dynamically, and fill result set data into Excel file. And then finally sent Excel file to Specific user[Email ID].
Point is that the excel file should have unique name so i want to give name as name_date_time.
So every time when package run new file is created with unique name.
Can any one suggest me who to create Excel file and fill result set data into Excel file.
And then finally send that Excel file ?
I have a package which loads data from a flat file source to an OLEDB destination, which is executed successfully and data is loaded perfectly.
But later when the data in the flat file source is modified i.e. if an extra column gets added to the text file, the package is throwing an error because it is unable to detect the extra added column.
How can i avoid this error??? I need my package to execute successfully ignoring the changes(added columns) happened in the flat file source.
Please provide me wth your suggestions and solutions....
Thanks in Advance!!
in my SSIS package, i have a Dataflow Task,
it reads data from text file and store into db table, in this data flow task i have only flatfile source and oledb destination nothing else (such as derived columns etc)
is there any way that i can improve the performance, each feeds has 13 columns with 70,000 rows in it
could you please tell me how to optimize this dfd step if exist any
thanks in advabce
I downloaded the Delimiter File Read and followed the instruction and installed it. The file is on the correct directory (>:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents)
The file DelimitedFileReader.dll is there.
However, when I go to BI Development Studio and try to add the new task I can't see it in the SSIS Data Flow Items...it is not visible. Does anyone know why I can add/see it?