slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - SSIS/DTS
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SSIS/DTS | New Thread

View: Search:

Author

Thread: Reading data into global variable

Valeda
Posts: 15

Reading data into global variable Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jul 06 9:42 AM

Hi me again,

This time I need to read from an existing table and set my global variable to the value from a table field. I have tried setting the input and output variables for the sql task, but it does not seem to pick up the table values.

[Reply][Quote]

Bryan McGuire
Posts: 1

Re: Reading data into global variable Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jul 06 10:30 AM

Hi,

Go here;

http://www.sqldts.com/default.aspx?280

This tutorial should get you on your way

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Reading data into global variable Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jul 06 11:54 AM

Using the Output variable is the way to go. Are all fields in your sql task aliased? (and you're not using something like "select *"?) It won't show the field names listed in the drop down for the output variables unless it can parse from your SQL statement the names of the fields that will be in the reesult.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Reading data into global variable Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jul 06 11:56 AM

sqldts.com is a great site. I've been a long time fan of that one. Darren's other new site for integration services is every bit as awesome http://www.sqlis.com/

[Reply][Quote]

Valeda
Posts: 15

Re: Reading data into global variable Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jul 06 12:49 PM

Thanks Sir Ryan Farley. You have been knighted.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 3:56:49 PM