How SSIS OLEDB Source component identifies the datatype of the source file columns automatically ?
I know we can go and change it but still how it identifies what goes at the backend ?
View Complete Post
I have a requirement where i had to migrate the table structure and data from ODBC database to SQL Server. I have dynamic source reader that uses sql query from variable to get the data and the next step is to get the create statement and create table and
then to insert data. how can i get Create Statement the destination produces and use sql task to create the table and then insert the data using data flow task.
The flat file is having 10 columns so used 9 delimitor. Few records in the Flat file is having more than 10 columns. I need to redirect in to some error table and rest valid records needs to be loaded in target. Pls help.
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!!
I need an efficient way of counting number of rows coming from source and also going to destination after passing through all the transformations.I know row count transformation is there but as it aggregates and makes the flow very slow with heavey volume,
i dont want to use it.
Pls suggest me some good way of counting rows, source can be flat file/excel/access/sql server
I have a connection string
="/f c:\test\test2\test2\package.dtsx /set \package.variables[User::varfil].Value;" & Parameters!varempid.Value
but its not returning any results.
I've a scenario in which i need to map my xml file to multiple sql server tables, maintaining Referential Integrity.
Below is my sample xml structure
<Hdr_ID>ID of the above record</Hdr_ID>
as u can see above, 1 parent record has 2 child records. So i need to save the parent record first, based on the ID which is generated automatically, i need to save my child records into the Detail table. I've searched everywhere in google, but couldn't
get a solution yet.
(I had done this sort of thing in vb.net but now my job is to do it using SSIS) :(
Can you gurus help me in achieving my task.
Thanks in advance.
but its not returning any results. I need a valid connection string.