Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, November 8, 2024 
 
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 ThreadView:  Search:  
 Author  Thread: Reading data into global variable
Valeda
Posts: 15
 
Reading data into global variableYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jul 06 9:42 AM
fiogf49gjkf0d
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 variableYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jul 06 10:30 AM
fiogf49gjkf0d
Hi,

Go here;

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

This tutorial should get you on your way
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Reading data into global variableYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jul 06 11:54 AM
fiogf49gjkf0d
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
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Reading data into global variableYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jul 06 11:56 AM
fiogf49gjkf0d
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 variableYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Jul 06 12:49 PM
fiogf49gjkf0d
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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/8/2024 2:53:58 AM