Robb Hill
asked on
SQL Server 2008 - SSIS transform
I am creating a sql ssis package.
The basics of the package is it takes data from a view in Oracle...and puts it in a table in SQL Server.
To get the package started I just used the wizard and made an ssis package that way...then copied that into a more advanced template I have.
However...this is my issue. Lets say I have a column called account number. In Oracle it comes over as a varchar(11)...when in fact in sql server I am going to want that to be a varchar(7). There must be some type of inherent padding in Oracle....
Should I handle this trimming of the fields in the process of it moving from Oracle to sql...
or should I take the table once its in sQL server..and transform it a second time to sql server?
Any suggestions?
Thanks
The basics of the package is it takes data from a view in Oracle...and puts it in a table in SQL Server.
To get the package started I just used the wizard and made an ssis package that way...then copied that into a more advanced template I have.
However...this is my issue. Lets say I have a column called account number. In Oracle it comes over as a varchar(11)...when in fact in sql server I am going to want that to be a varchar(7). There must be some type of inherent padding in Oracle....
Should I handle this trimming of the fields in the process of it moving from Oracle to sql...
or should I take the table once its in sQL server..and transform it a second time to sql server?
Any suggestions?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim
ASKER
I will just scrub my staging table and make a new table with all the trimmings..
Thanks for your input!