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?