I've done basic table loads with SSIS and had success but now have a complicated report to load.
The format is similar to this:
TransactionID UserID firstname lastname itemID itemdescription itemcost
100001 1001 Joe Jones abc black shoes $50.
100002 1002 Jane...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.