Friday, March 30, 2012
Loss of Column properties when exporting with DTS
Wednesday, March 28, 2012
Looping thru time..
I have a DTS PACKAGE IN SQL 2000 where I need to use vbscript to loop thru the files. I have the package detecting the directory - and the file, BUT the file itself has an interval number from 1- 48 set within it. So in one day I am getting 48 different files.
I can not delete previous files or move them - so I need to - each day - loop thru the day for each interval.
Any thoughts on how I can do this?
Interval 1 = 12:00 AM
Interval 2 = 12:30 AM
Interval 3 = 1:00 AM
etc. etc.
Thanks!
M
I am not clear exactly what you're after. If you want to translate intervals into respective times for the 48 intervals, you can do like so:
Code Snippet
--create dummy #digits table
select top 48 i=identity(int,1,1)
into #digits
from syscolumns
--the query
select i, right(convert(varchar,dateadd(minute,(i-1)*30,0),100),7) [time]
from #digits
--drop #digits
drop table #digits
Well not exactly taking the intervals and transposing them into a time. Each interval means it is a certain time frame (a 30 min time frame within the 24 hours - giving me a total of 48 intervals in a day).
The file that I get - I get 48 times a day. So I have to loop thru the 48 files in activex for the dts. And I am a bit stuck on that part.
|||Moved to the SSIS forum, since you are looking for a solution with no T-SQL code. This is more likely to have someone to answer it here. Thanks
|||Are you trying to do this in DTS or SSIS? If it's DTS, try this newsgroup - microsoft.public.sqlserver.dts.|||Forums site is screwy - finally was able to get in and edit/reply... this is for DTS in SQL 2000...Looping thru time..
I have a DTS PACKAGE IN SQL 2000 where I need to use vbscript to loop thru the files. I have the package detecting the directory - and the file, BUT the file itself has an interval number from 1- 48 set within it. So in one day I am getting 48 different files.
I can not delete previous files or move them - so I need to - each day - loop thru the day for each interval.
Any thoughts on how I can do this?
Interval 1 = 12:00 AM
Interval 2 = 12:30 AM
Interval 3 = 1:00 AM
etc. etc.
Thanks!
M
I am not clear exactly what you're after. If you want to translate intervals into respective times for the 48 intervals, you can do like so:
Code Snippet
--create dummy #digits table
select top 48 i=identity(int,1,1)
into #digits
from syscolumns
--the query
select i, right(convert(varchar,dateadd(minute,(i-1)*30,0),100),7) [time]
from #digits
--drop #digits
drop table #digits
Well not exactly taking the intervals and transposing them into a time. Each interval means it is a certain time frame (a 30 min time frame within the 24 hours - giving me a total of 48 intervals in a day).
The file that I get - I get 48 times a day. So I have to loop thru the 48 files in activex for the dts. And I am a bit stuck on that part.
|||Moved to the SSIS forum, since you are looking for a solution with no T-SQL code. This is more likely to have someone to answer it here. Thanks
|||Are you trying to do this in DTS or SSIS? If it's DTS, try this newsgroup - microsoft.public.sqlserver.dts.|||Forums site is screwy - finally was able to get in and edit/reply... this is for DTS in SQL 2000...Friday, March 23, 2012
Looping problem in DTS with ActiveX
(a) a holding table is truncated and 1 blank record is inserted into the holding table,
(b) the XML data in the file is inserted into the holding table via TextCopy.exe,
(c) the XML data is parsed using OPENXML and inserted into 2 additional holding tables, and
(d) the XML file is archived to another directory.
After (a), (b), (c), and (d) are completed, the DTS package loops back and executes (a), (b), (c), and (d) for the other remaining files.
It all worked flawlessly in testing, until I commented out a MsgBox line in the ActiveX task for item (b) above. Without the MsgBox command, the other tasks (b) and (c) don't appear to execute, though I can see that the looping is working, since the source files get moved to the archive location (in step (d)).
Attached is a screenshot of the DTS package (it can also be viewed at http://www.nmwildlife.org/images/DTS_screenshot.gif).
I think that the MsgBox issue is a red herring; in other words, I'm thinking that when I click the OK button on the MsgBox, there might be something about the return code which allows the tasks to be executed properly. However, I'm not a VBScript expert, so can't figure out where the problem lies or how to fix it.
Here's the code for the "Import w/ShellCmd" ActiveX task:
Function Main()
Dim objShell
Dim strPath
Dim strCmd
strPath = CSTR(DTSGlobalVariables("gv_FileFullName").Value)
strCmd = """C:\Program Files\Microsoft SQL Server\MSSQL\Binn\TextCopy.exe"" /S ""GROVER"" /U sa /P """" /D TESTProlaw /T dc_XML /C myXML /F " & _
strPath & _
" /W ""WHERE 1=1"" /I /Z"
Set objShell = CreateObject("WScript.Shell")
objShell.Run strCmd
Set objShell = nothing
MsgBox ""
Main = DTSTaskExecResult_Success
End Function
And here's the code for the "Begin Loop" ActiveX task:
Option Explicit
Function Main()
dim pkg
dim stpEnterLoop
dim stpFinished
set pkg = DTSGlobalVariables.Parent
set stpEnterLoop = pkg.Steps("DTSStep_DTSExecuteSQLTask_2") 'Start loop at the "Truncate dc_XML" task
set stpFinished = pkg.Steps("DTSStep_DTSActiveScriptTask_5")
' We want to continue with the loop only of there are more than 1 text file in the directory.
' If the function ShouldILoop returns true then we disable the step that takes us out of the package and continue processing
if ShouldILoop = True then
stpEnterLoop.DisableStep = False
stpFinished.DisableStep = True
stpEnterLoop.ExecutionStatus = DTSStepExecStat_Waiting
else
stpEnterLoop.DisableStep =True
stpFinished.DisableStep = False
stpFinished.ExecutionStatus = DTSStepExecStat_Waiting
End if
Main = DTSTaskExecResult_Success
End Function
Function ShouldILoop
dim fso
dim fil
dim fold
dim pkg
dim counter
set pkg = DTSGlobalVariables.Parent
set fso = CREATEOBJECT("Scripting.FileSystemObject")
set fold = fso.GetFolder(DTSGlobalVariables("gv_FileLocation").Value)
counter = fold.files.count
'So long as there is more than 1 file carry on
if counter >= 1 then
for each fil in fold.Files
DTSGlobalVariables("gv_FileFullName").Value = fil.path
ShouldILoop = CBool(True)
Next
else
ShouldILoop = CBool(False)
End if
End Function
The goal is to get the DTS package to run without having to manually click OK on the MsgBox; that way, I can schedule it to run automatically.
Any help would be greatly appreciated. Thanks in advance!no, here the MsgBox is not returning anything. it should run perfectly without the MsgBox. i think it was used to give the shell the time to complete the process.
what u can try is - executing the shell in sync mode and drop the MsgBox. use this code and see if it works
....
Ret = objShell.Run (strCmd,,true)
.....sql
Looping a stored procedure in a dts package
I have a stored procedure that processes an individual file from a
directory and archives it in a subdirectory.Now, the problem is, when i
execute it , it will only process one file. What i want to do is to check
to see if there are any files in the folder, and if there are , process
them all, and once done, go to the next part in a DTS package, if there are
no files, simply go to the next part in the DTS package. I tried an activex
script that would get the filecount in the folder, and if there were more
than 0 files in the folder, then DTS-sUCCESS and on "success" workflow , it
would run the stored procedure, and thus it woould process one file, then
"on completion" the workflow connected it back to the activeX script(thus
looping), which would count the files again. Now if there were 0 files, it
would report DTS_FAILIURE, and I had it set up ,"on failiure" to go to the
next step in the package, but it wouldn't run.
Someone mind showing me a ray of light?What you can do is create another SP (Parent SP)which is a wrapper on
the current SP .
Read the files one by one in the main SP and call your SP .
In DTS flow replace the current SP with Parent SP.
Srinivas
Alex wrote:
Quote:
Originally Posted by
Hello,
>
I have a stored procedure that processes an individual file from a
directory and archives it in a subdirectory.Now, the problem is, when i
execute it , it will only process one file. What i want to do is to check
to see if there are any files in the folder, and if there are , process
them all, and once done, go to the next part in a DTS package, if there are
no files, simply go to the next part in the DTS package. I tried an activex
script that would get the filecount in the folder, and if there were more
than 0 files in the folder, then DTS-sUCCESS and on "success" workflow , it
would run the stored procedure, and thus it woould process one file, then
"on completion" the workflow connected it back to the activeX script(thus
looping), which would count the files again. Now if there were 0 files, it
would report DTS_FAILIURE, and I had it set up ,"on failiure" to go to the
next step in the package, but it wouldn't run.
>
Someone mind showing me a ray of light?
Monday, March 12, 2012
Lookup problem
I have a problem related to execution of a lookup in a transformation script in SQL server 2000 DTS package.
I have a lookup that launches a stored procedure:
EXECUTE TableID ?, ? output
This lookup is executed from a script like this:
Dim newID as integer
DTSLookups("GetNewID").Execute "string_data", newID
The problem is that the second parameter (it is an output parameter) is unchanged althghough it is changed in the stored procedure
Any suggestions ?
Thank you, Gabyx
The Execute method won't assign a value to newID. It returns a value, or array of values.
Try this:
Dim newID as integer
newID = DTSLookups("GetNewID").Execute "string_data", newID
Let me know if this works for you.
Look-up during DTS
Not too sure where to start look so I'm going to ask if anyone can point me
in the right direction.
I have an XLS workbook that I want to DTS into a SQL Server table named
transactions.
A column in the XLS is ACCOUNT NUMBER.
In my SQL server I have an accounts table that has accountID as the PK. It
also has an accountNumber field.
Is there a way to do a lookup on the accounts table so that the DTS can put
in the accountID of the matching accountNumber into the transactions table?
Thanks,
Won LeeThis is a multi-part message in MIME format.
--=_NextPart_000_0011_01C36AFB.7FD5A7F0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Yes, you can:
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/dnsqlp=
ro2k/html/sql00l5.asp
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Won Lee" <noemail> wrote in message =news:e4VTdoxaDHA.1872@.TK2MSFTNGP12.phx.gbl...
Hello,
Not too sure where to start look so I'm going to ask if anyone can point =me
in the right direction.
I have an XLS workbook that I want to DTS into a SQL Server table named
transactions.
A column in the XLS is ACCOUNT NUMBER.
In my SQL server I have an accounts table that has accountID as the PK. =It
also has an accountNumber field.
Is there a way to do a lookup on the accounts table so that the DTS can =put
in the accountID of the matching accountNumber into the transactions =table?
Thanks,
Won Lee
--=_NextPart_000_0011_01C36AFB.7FD5A7F0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Yes, you can:
http://msdn.microsoft.com/library/default.=asp?url=3D/library/en-us/dnsqlpro2k/html/sql00l5.asp
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Won Lee" wrote in message news:e4VTdoxaDHA.1872=@.TK2MSFTNGP12.phx.gbl...Hello,Not too sure where to start look so I'm going to ask if anyone can point =mein the right direction.I have an XLS workbook that I want to DTS =into a SQL Server table namedtransactions.A column in the XLS is ACCOUNT NUMBER.In my SQL server I have an accounts table that has accountID =as the PK. Italso has an accountNumber field.Is there a way to do =a lookup on the accounts table so that the DTS can putin the accountID =of the matching accountNumber into the transactions =table?Thanks,Won Lee
--=_NextPart_000_0011_01C36AFB.7FD5A7F0--|||Thank you. I will read the article right now.
Won Lee
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ePeHE0xaDHA.2476@.tk2msftngp13.phx.gbl...
Yes, you can:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00l5.asp
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Won Lee" <noemail> wrote in message
news:e4VTdoxaDHA.1872@.TK2MSFTNGP12.phx.gbl...
Hello,
Not too sure where to start look so I'm going to ask if anyone can point me
in the right direction.
I have an XLS workbook that I want to DTS into a SQL Server table named
transactions.
A column in the XLS is ACCOUNT NUMBER.
In my SQL server I have an accounts table that has accountID as the PK. It
also has an accountNumber field.
Is there a way to do a lookup on the accounts table so that the DTS can put
in the accountID of the matching accountNumber into the transactions table?
Thanks,
Won Lee|||Whilst Tom's article points to a good solution one to be aware of is
Pump into a scratch table and then use TSQL to do the lookups.
This should perform better the more records you have in Excel as with a
lookup solution in a DTS DataPump task DTS has to issue another statement
for every single row and the larger the source the longer it takes.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org|||Another good suggestion.
I was unable to get the solution Tom Suggested to work.
I always thought DTS with a direct column copy was a data pump but it
doesn't look like it now.
I also tried to do an ActiveX copy with a DDQ but also had some problems.
This may be the solution I'm looking for.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:%23OtljXzaDHA.3248@.tk2msftngp13.phx.gbl...
> Whilst Tom's article points to a good solution one to be aware of is
> Pump into a scratch table and then use TSQL to do the lookups.
> This should perform better the more records you have in Excel as with a
> lookup solution in a DTS DataPump task DTS has to issue another statement
> for every single row and the larger the source the longer it takes.
>
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org|||What errors do you get?
DTS can be a "Copy Column" but it can be so much more too.
DDQ can be confusing but is also quite powerful.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Won Lee" <noemail> wrote in message
news:uCdzAh8aDHA.1384@.TK2MSFTNGP10.phx.gbl...
> Another good suggestion.
> I was unable to get the solution Tom Suggested to work.
> I always thought DTS with a direct column copy was a data pump but it
> doesn't look like it now.
> I also tried to do an ActiveX copy with a DDQ but also had some problems.
> This may be the solution I'm looking for.
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:%23OtljXzaDHA.3248@.tk2msftngp13.phx.gbl...
> > Whilst Tom's article points to a good solution one to be aware of is
> >
> > Pump into a scratch table and then use TSQL to do the lookups.
> >
> > This should perform better the more records you have in Excel as with a
> > lookup solution in a DTS DataPump task DTS has to issue another
statement
> > for every single row and the larger the source the longer it takes.
> >
> >
> >
> > --
> >
> >
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
>|||I used the import wizzard to create the DTS package.
Afterwards I looked at the DTS package to edit the the LookUP portion, as
directed by Tom's article.
I created a new connection to the DB and added the following code to the
lookup query.
select accountID from accounts where MCName = ?
I didn't know where the put the rest of the code.
I then designed a new DTS package. I used the ActiveX option to bring over
each column individually and was going to change the VB
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:u%23YlMs8aDHA.1748@.TK2MSFTNGP12.phx.gbl...
> What errors do you get?
> DTS can be a "Copy Column" but it can be so much more too.
> DDQ can be confusing but is also quite powerful.
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Won Lee" <noemail> wrote in message
> news:uCdzAh8aDHA.1384@.TK2MSFTNGP10.phx.gbl...
> > Another good suggestion.
> > I was unable to get the solution Tom Suggested to work.
> > I always thought DTS with a direct column copy was a data pump but it
> > doesn't look like it now.
> > I also tried to do an ActiveX copy with a DDQ but also had some
problems.
> > This may be the solution I'm looking for.
> >
> > "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> > news:%23OtljXzaDHA.3248@.tk2msftngp13.phx.gbl...
> > > Whilst Tom's article points to a good solution one to be aware of is
> > >
> > > Pump into a scratch table and then use TSQL to do the lookups.
> > >
> > > This should perform better the more records you have in Excel as with
a
> > > lookup solution in a DTS DataPump task DTS has to issue another
> statement
> > > for every single row and the larger the source the longer it takes.
> > >
> > >
> > >
> > > --
> > >
> > >
> > > Allan Mitchell (Microsoft SQL Server MVP)
> > > MCSE,MCDBA
> > > www.SQLDTS.com
> > > I support PASS - the definitive, global community
> > > for SQL Server professionals - http://www.sqlpass.org
> >
> >
>
Friday, March 9, 2012
Looking for Wayne Snyder
Taking LearnKey course SQL 2000 Implementing DB Design. In session 8 you
use a file called "bulk insert package.dts", I have looked for the script on
all of the LearnKey downloads and the CD and can not find it. Is there any
place I can get it?
Actually I was able to recreate the bulk insert package, but the rest of the
*.dts files are missing, it would be real helpful to have then to go along
with the course.
"DazedAndConfused" <AceMagoo61@.yahoo.com> wrote in message
news:eD%23xNR7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
> Wayne,
> Taking LearnKey course SQL 2000 Implementing DB Design. In session 8
> you use a file called "bulk insert package.dts", I have looked for the
> script on all of the LearnKey downloads and the CD and can not find it. Is
> there any place I can get it?
>
|||hi
got his email
visit this site
http://www.solidqualitylearning.com/...AboutWayne.htm
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"DazedAndConfused" wrote:
> Actually I was able to recreate the bulk insert package, but the rest of the
> *.dts files are missing, it would be real helpful to have then to go along
> with the course.
> "DazedAndConfused" <AceMagoo61@.yahoo.com> wrote in message
> news:eD%23xNR7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
>
>
Looking for Wayne Snyder
Taking LearnKey course SQL 2000 Implementing DB Design. In session 8 you
use a file called "bulk insert package.dts", I have looked for the script on
all of the LearnKey downloads and the CD and can not find it. Is there any
place I can get it?Actually I was able to recreate the bulk insert package, but the rest of the
*.dts files are missing, it would be real helpful to have then to go along
with the course.
"DazedAndConfused" <AceMagoo61@.yahoo.com> wrote in message
news:eD%23xNR7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
> Wayne,
> Taking LearnKey course SQL 2000 Implementing DB Design. In session 8
> you use a file called "bulk insert package.dts", I have looked for the
> script on all of the LearnKey downloads and the CD and can not find it. Is
> there any place I can get it?
>|||hi
got his email
visit this site
http://www.solidqualitylearning.com/Resumes/Wayne/AboutWayne.htm
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"DazedAndConfused" wrote:
> Actually I was able to recreate the bulk insert package, but the rest of the
> *.dts files are missing, it would be real helpful to have then to go along
> with the course.
> "DazedAndConfused" <AceMagoo61@.yahoo.com> wrote in message
> news:eD%23xNR7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Wayne,
> >
> > Taking LearnKey course SQL 2000 Implementing DB Design. In session 8
> > you use a file called "bulk insert package.dts", I have looked for the
> > script on all of the LearnKey downloads and the CD and can not find it. Is
> > there any place I can get it?
> >
>
>
Looking for Wayne Snyder
Taking LearnKey course SQL 2000 Implementing DB Design. In session 8 you
use a file called "bulk insert package.dts", I have looked for the script on
all of the LearnKey downloads and the CD and can not find it. Is there any
place I can get it?Actually I was able to recreate the bulk insert package, but the rest of the
*.dts files are missing, it would be real helpful to have then to go along
with the course.
"DazedAndConfused" <AceMagoo61@.yahoo.com> wrote in message
news:eD%23xNR7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
> Wayne,
> Taking LearnKey course SQL 2000 Implementing DB Design. In session 8
> you use a file called "bulk insert package.dts", I have looked for the
> script on all of the LearnKey downloads and the CD and can not find it. Is
> there any place I can get it?
>|||hi
got his email
visit this site
http://www.solidqualitylearning.com.../AboutWayne.htm
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"DazedAndConfused" wrote:
> Actually I was able to recreate the bulk insert package, but the rest of t
he
> *.dts files are missing, it would be real helpful to have then to go along
> with the course.
> "DazedAndConfused" <AceMagoo61@.yahoo.com> wrote in message
> news:eD%23xNR7sFHA.2592@.TK2MSFTNGP09.phx.gbl...
>
>
Looking for very good SQL Server DTS books
I'm searching for some good must-have books on SQL Server DTS. If you
are in the DTS business daily, you probably know which books are good
for DTS. I can browse some online book reviews but they are not all
trustworthy...I trust you better...hihi.
Please do me a favor.
Thanks.
TrentI listed a few DTS books at: http://vyaskn.tripod.com/sqlbooks.htm#dts
I personally haven't read any of them. But I did read, "SQL Server 2000 Fast
Answers for SQL Server DBAs and Developers". This is a good book, and
provides you with all the information you need, to get started on DTS:
http://vyaskn.tripod.com/sql_server...ast_answers.htm
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Trent" <pineme@.yahoo.com> wrote in message
news:7ad7239b.0408181244.152a693d@.posting.google.c om...
> Hello, folks.
> I'm searching for some good must-have books on SQL Server DTS. If you
> are in the DTS business daily, you probably know which books are good
> for DTS. I can browse some online book reviews but they are not all
> trustworthy...I trust you better...hihi.
> Please do me a favor.
> Thanks.
> Trent
Saturday, February 25, 2012
Looking for ideas
Hi everyone
We've got currenlty around 500 dts 2000 in production.
In order to know in what ETL processes we have Oracle connections, or FTP tasks or whatever, we did a VB6 app using dtspkg.dll which load all the properties for each DTS into Sql server tables. So that, then you could see from a specific DTS how many connections, Sql Tasks it had and so on..
How to accomplish the same with SSIS? I know, doing the same but using .Net, of course, but is there any else approximation? I am little bit concerned when we will have hundreds of them up.
Maybe 2005 is offering this feature automatically, I don't know.
Thanks in advance for your time/advices/ideas,
Try this -
Download details: SQL Server 2005 Business Intelligence Metadata Samples Toolkit
(http://www.microsoft.com/downloads/details.aspx?FamilyID=11daa4d1-196d-4f2a-b18f-891579c364f4&DisplayLang=en)
Even if the tools are visualisation is not what you want, it will have populated some tables with details of packages and objects that you can probably use. And if that is still not good enough the source code included will give you a start in writing your own tool.
Monday, February 20, 2012
Looking for DTS example
I am trying to automate calling a SQL Copy Data task. I need to provide the
source database dynamically at the least. I am using MSDE in a C3 program.
Does anyone have any examples or sites they can point me to? I am at a loss
after much searching.
ThanksMe too.
Apparently exporting a DTS to VB gives you the option of actually
controlling the DTS batch more, but you need Visual Basic installed (dunno
if it'll run in a VBA environment).
I've tried a DTS storage file & metadata services, the DTS storage file is
in binary and I can't get metadata services working just now...
+--
To e-mail me,
replace "REPLACETHIS" with buddhashortfatguy
"S" <spamaway@.hotmail.com> wrote in message
news:OG5F71TqDHA.1408@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I am trying to automate calling a SQL Copy Data task. I need to provide
the
> source database dynamically at the least. I am using MSDE in a C3
program.
> Does anyone have any examples or sites they can point me to? I am at a
loss
> after much searching.
> Thanks
>