Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-03-06 : 09:26:19
|
| I'm using SQL Server 2005. I have created a dts package but I want it to be date driven. Meaning when the package runs can I have it prompt me for a date? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-06 : 09:46:58
|
| why would you do that? prompt you that is. are you going to be there in front of the SSIS package at the specific time it is running?Just use default date GETDATE(), otherwise it defeats the purpose of SSIS automation. |
 |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2009-03-06 : 10:37:24
|
| Good point. I was using SSIS because it is much faster than MS Access. Right now the process is in access and it takes forever but I have been redesigning it to use sql server and it's much faster. Can I run a dts package from MS Access? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-06 : 13:58:12
|
| use the following as basis to see how it is done.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81870while you are at it you might want to move to .Net world C# :) we are planning to get away from .ADP. I say that because you can call SSIS packages from C#. but for Access maybe if you there is a SSIS package object reference you might be able to?2 cents |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-06 : 14:18:36
|
| look under C:\Program Files\Microsoft SQL Server\90\DTS\Binn wherever you haev SQl management tools is installed. You will see many dlls and exe that could point you to right direction. DTExec.exe especially google that and you will find many good things. |
|
|
|
|
|
|
Date parameter in DTS package