troubleshooting Question

SSiS SQL 2005: Passing a derived column into a variable

Avatar of moosetracker
moosetracker asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
5 Comments1 Solution507 ViewsLast Modified:
Ok from what I can see you can not pass a derived column into a variable directly, but if you don't want to pass any data into a flat file or SQL Server, but just pull it from ODBC and alter it with derived column, you can move it to varibles...  HOW???...
Right now I have created an unwanted SQL table, have to clear it so I can put the Derived info into it.. So that I can pull it out to put in a variable.. There must be a better way.
ASKER CERTIFIED SOLUTION
Reza Rad
Consultant, Trainer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros