?
Solved

[ActiveX Script] Copy file to a certain directory

Posted on 2009-02-09
6
Medium Priority
?
342 Views
Last Modified: 2013-11-30
At this moment (after exporting data to a csv file) i copy the file to a certain directory with datetag. Using Createfolder en CopyFile

so .. dir 20090101 contains a file .. 20090102 contains a file etc etc..

how can i change this to a follow-up number .. so no longer a datetag but every day a dir is created with a higher number then the day before

Thanks in advanced

0
Comment
Question by:Amien90
  • 4
  • 2
6 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 1000 total points
ID: 23588962
you can define a variable to represent your directory and filename string and in an expression you can define the current value of the variable.
an example implementation of this is described in the following link

http://www.mssqltips.com/tip.asp?tip=1395
0
 

Author Comment

by:Amien90
ID: 23589243
and this is also possible with DTS/ Server 2000?
0
 
LVL 26

Expert Comment

by:tigin44
ID: 23592607
at sql server 2000 dts packages it is defined by activex scripts.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Amien90
ID: 23594091
easy .. thanks

0
 

Author Comment

by:Amien90
ID: 23598161
is it not possible to use this variable directly in the export? so without using the activex script.. but directly in the filename / Transformation data task
0
 

Author Comment

by:Amien90
ID: 23603693
for some reason .. DTSGlobalVariables("counter").value = DTSGlobalVariables("counter").value + 1 is adding + 1 sometimes .. and sometimes not
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question