Viewing 15 posts - 12,976 through 12,990 (of 13,841 total)
Robert Ham (2/3/2009)
You can also pass variables from a parent package that uses the execute package task to run a child package.
So multiple child packages can read/write the same 'parent'...
February 3, 2009 at 11:09 pm
Scoping of variables at global or 'solution' level is not possible - so you have to find another way.
One way is to create a physical 'variables' table in SQL Server...
February 3, 2009 at 6:46 pm
This is how I would do it - no scripts required:
1) Create a new SQL Server table to hold the Access data temporarily (tblAS).
2) Write a stored proc on SQL...
February 3, 2009 at 5:33 am
If you can get just a bit more specific, I think we can help you.
What do you mean by 'validate'? Is there a certain column that always has a certain...
February 3, 2009 at 5:25 am
For one solitary piece of data it's certainly a pain - but if you are generic about how you write it you will be able to reuse in future.
Phil
February 2, 2009 at 7:17 pm
Not really. You might consider creating a physical 'Variables' table in SQL Server and using that to store/lookup any variables which are truly global.
Phil
February 2, 2009 at 7:06 pm
That's not a great error message:) Maybe it should just have said: "Something, somewhere, is wrong."
I just tried one on my system. Try this:
Resultset = None
SQLSourceType = Direct Input
SQL Statement...
February 2, 2009 at 6:35 pm
I suggest that you concentrate on getting the sp working fast on its own without worrying about SSIS for now.
You should try to work out where the bottleneck is: is...
February 1, 2009 at 7:37 pm
Add an Execute SQL task. Set the appropriate Connection info, then set the SQL Statement property to
EXEC sp_name
where sp_name is the name of your stored proc.
Phil
February 1, 2009 at 7:30 pm
Are you asking whether it is possible to write a query that accesses data from SQL Server and Access?
I agree that you need to expand on what you mean by...
January 30, 2009 at 7:01 pm
You might investigate using the file watcher task - check this thread for more details:
http://www.sqlservercentral.com/Forums/Topic493253-148-1.aspx
Phil
January 19, 2009 at 8:11 am
Can you use a script task?
If so, you can put the filename into a variable and then process it.
There may be an easier way, but script will work for sure.
Phil
January 13, 2009 at 2:58 am
Agreed and done.
Phil
January 13, 2009 at 2:47 am
If you enjoyed answering this question, you can do it all over again here:
http://www.sqlservercentral.com/Forums/Topic634483-148-1.aspx
Phil
January 13, 2009 at 2:45 am
Is this a homework question from a college course, by any chance?
This thread looks too similar to be a coincidence:
http://www.sqlservercentral.com/Forums/Topic634303-148-1.aspx
Phil
January 12, 2009 at 3:16 am
Viewing 15 posts - 12,976 through 12,990 (of 13,841 total)