 | |
Creating dynamic file name
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Creating dynamic file name -
11-07-2003
, 08:57 AM
#2
| |||
| |||
|
|
Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
#3
| |||
| |||
|
|
-----Original Message----- How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter . |
#4
| |||
| |||
|
|
-----Original Message----- How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter . |
#5
| |||
| |||
|
|
How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
#6
| |||
| |||
|
|
Can someone provide me an example of doing this using SQL Server 2000 (using Dynamic Properties Task) "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:%236Ze1rUpDHA.3616 (AT) tk2msftngp13 (DOT) phx.gbl... How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
#7
| |||
| |||
|
|
You would have to assign the value of the text file to the DataSource property of the text file connection. This should in turn change the DestinationObjectName of the DataPump task. -- -- 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 "Berny" <BlancoB at msn Dot com> wrote in message news:eRCHtbhuDHA.2408 (AT) tk2msftngp13 (DOT) phx.gbl... Can someone provide me an example of doing this using SQL Server 2000 (using Dynamic Properties Task) "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:%236Ze1rUpDHA.3616 (AT) tk2msftngp13 (DOT) phx.gbl... How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
#8
| |||
| |||
|
|
Is there anywhere Ican see an example of this? I've never done this and need something to follow the first time. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uCRp1TjuDHA.1088 (AT) tk2msftngp13 (DOT) phx.gbl... You would have to assign the value of the text file to the DataSource property of the text file connection. This should in turn change the DestinationObjectName of the DataPump task. -- -- 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 "Berny" <BlancoB at msn Dot com> wrote in message news:eRCHtbhuDHA.2408 (AT) tk2msftngp13 (DOT) phx.gbl... Can someone provide me an example of doing this using SQL Server 2000 (using Dynamic Properties Task) "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:%236Ze1rUpDHA.3616 (AT) tk2msftngp13 (DOT) phx.gbl... How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
#9
| |||
| |||
|
|
I don't know of an example on the web but I can send you one if you want? -- -- 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 "Berny" <BlancoB at msn Dot com> wrote in message news:OwPZPKmuDHA.2060 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Is there anywhere Ican see an example of this? I've never done this and need something to follow the first time. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uCRp1TjuDHA.1088 (AT) tk2msftngp13 (DOT) phx.gbl... You would have to assign the value of the text file to the DataSource property of the text file connection. This should in turn change the DestinationObjectName of the DataPump task. -- -- 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 "Berny" <BlancoB at msn Dot com> wrote in message news:eRCHtbhuDHA.2408 (AT) tk2msftngp13 (DOT) phx.gbl... Can someone provide me an example of doing this using SQL Server 2000 (using Dynamic Properties Task) "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:%236Ze1rUpDHA.3616 (AT) tk2msftngp13 (DOT) phx.gbl... How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
#10
| |||
| |||
|
|
I would really appreciate that!!! Thanks BlancoB at MSN dot Com "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:OXoXzXmuDHA.640 (AT) tk2msftngp13 (DOT) phx.gbl... I don't know of an example on the web but I can send you one if you want? -- -- 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 "Berny" <BlancoB at msn Dot com> wrote in message news:OwPZPKmuDHA.2060 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Is there anywhere Ican see an example of this? I've never done this and need something to follow the first time. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uCRp1TjuDHA.1088 (AT) tk2msftngp13 (DOT) phx.gbl... You would have to assign the value of the text file to the DataSource property of the text file connection. This should in turn change the DestinationObjectName of the DataPump task. -- -- 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 "Berny" <BlancoB at msn Dot com> wrote in message news:eRCHtbhuDHA.2408 (AT) tk2msftngp13 (DOT) phx.gbl... Can someone provide me an example of doing this using SQL Server 2000 (using Dynamic Properties Task) "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:%236Ze1rUpDHA.3616 (AT) tk2msftngp13 (DOT) phx.gbl... How can I change the filename for a text file connection? (http://www.sqldts.com/default.aspx?200) -- -- 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 "Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0c5901c3a53f$72953690$a301280a (AT) phx (DOT) gbl... Dear All, I would like to configure DTS to create dynamic filenames for a text file i.e. File_20031107.txt, does anyone know how to do it ? Thanks Peter |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.