Saving SSIS package connection passwords

Hello All,

I'm new to SQL 2005. I am setting up some SSIS packages which will connect to an Oracle database and copy some tables from it. These packages will then be scheduled to run on a daily basis. Because they will run automatically, it is required that passwords be saved along with the connection string. However, even though the password is saved (and encrypted, I checked the .dtsx in notepad), when I run the package, the connection to Oracle fails. Only if I respecify the password does it run correctly. How can I correctly save this password so that I can schedule automatic execution? Thanks for any info.

If you search this forum for "connection password" you'll get plenty of results. Basically, SSIS does not save passwords in connection strings.

Verify that your package property, ProtectionLevel, is set to EncryptSensitiveWithUserKey. If that doesn't work, then you can put the connection string for the Oracle database in a configuration file, of which you can manually update to contain the password. All of this is posted throughout this forum.|||

Hi,

Thanks for your reply. The thing about that is, that the package is owned by the OS user I use, but the Server Agent runs on another profile (System), so encrypting with a user key will make the Agent unable to execute de package. I wil check out the configuratio file thing, though.

|||Then you can do EncryptSensitiveWithPassword and specify the package password in SQL Agent by altering the dtexec command line parameters.|||I ran into your problem and my solution was to change the CreatorName property of the package to the account that SQL Agent runs under, and I also changed the CreatorComputerName to the name of the production server, then it finally workedsql

Saving and Restoring a SQL SERVER Table

Can anyone tell me how I can save or copy a SQL Server table and restore it
on another system?
I am running SQL Server 2000.
I see how I can export it to another database on my machine. But I need to
copy the table to another PC.
Any help is appreciated.
Ron
Hi
If you can export it into it's own database then a backup can be made and
restored on the other PC.
If the whole database is not big, then just take the whole backup. It is not
clear why you want the one table and not a whole consistent backup!
http://support.microsoft.com/kb/304692/EN-US/
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
> it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
> to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>
|||John
I only need one table to test with at another location.
I want to be able to copy one table to a floppy and then restore.
The backup option copies the whole database.
How can this be done?
"John Bell" wrote:

> Hi
> If you can export it into it's own database then a backup can be made and
> restored on the other PC.
> If the whole database is not big, then just take the whole backup. It is not
> clear why you want the one table and not a whole consistent backup!
> http://support.microsoft.com/kb/304692/EN-US/
> John
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
>
>
|||DTS can copy individual tables and their data to databases
on different servers.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>
|||I assume DTS stands for Data Transformation Service but that still doesn't
give me a clue how to save and restore an individual table.
"Armando Prato" wrote:

> DTS can copy individual tables and their data to databases
> on different servers.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> it
> to
>
>
|||Why do you need to save it and restore it? I think if worse came to worse,
you
could place it on it's on filegroup and go that route.
With DTS, you can copy the table directly and not jump through any hoops.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...[vbcol=seagreen]
> I assume DTS stands for Data Transformation Service but that still doesn't
> give me a clue how to save and restore an individual table.
> "Armando Prato" wrote:
restore[vbcol=seagreen]
need[vbcol=seagreen]
|||Are you going to tell me how to do that with DTS or do you just want to keep
me in suspence?
I already explained why I need to save & restore?
"Armando Prato" wrote:

> Why do you need to save it and restore it? I think if worse came to worse,
> you
> could place it on it's on filegroup and go that route.
> With DTS, you can copy the table directly and not jump through any hoops.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...
> restore
> need
>
>
|||Well, you could've done a wee bit of leg work and researched DTS.
DTS is a very simple tool that can be accessed right from
the Microsoft SQL Server folder on your server. The folder
entry is called "Import and Export Data". From there a wizard
launches that asks you your source and destination servers along
with a screen that lists all available tables on the source where you check
off the
one you want to export.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:DC936A64-DF31-45CB-B560-AADE917754B7@.microsoft.com...
> Are you going to tell me how to do that with DTS or do you just want to
keep[vbcol=seagreen]
> me in suspence?
> I already explained why I need to save & restore?
> "Armando Prato" wrote:
worse,[vbcol=seagreen]
hoops.[vbcol=seagreen]
doesn't[vbcol=seagreen]
I[vbcol=seagreen]
|||Hi
The point was that you can create a new database and copy the one table into
that. Then you backup contains the one table. You can then restore that
database and if necessary copy the table again. Alternatives would be to to
script the table and use DTS or BCP to export the data.
You may want to use a CD or USB flash device if this data/backup is bigger
than 1.44 MB.
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:CA95E845-DA13-4589-BAEC-D0B2852ED2CB@.microsoft.com...[vbcol=seagreen]
> John
> I only need one table to test with at another location.
> I want to be able to copy one table to a floppy and then restore.
> The backup option copies the whole database.
> How can this be done?
> "John Bell" wrote:

Saving and Restoring a SQL SERVER Table

Can anyone tell me how I can save or copy a SQL Server table and restore it
on another system?
I am running SQL Server 2000.
I see how I can export it to another database on my machine. But I need to
copy the table to another PC.
Any help is appreciated.
RonHi
If you can export it into it's own database then a backup can be made and
restored on the other PC.
If the whole database is not big, then just take the whole backup. It is not
clear why you want the one table and not a whole consistent backup!
http://support.microsoft.com/kb/304692/EN-US/
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
> it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
> to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>|||John
I only need one table to test with at another location.
I want to be able to copy one table to a floppy and then restore.
The backup option copies the whole database.
How can this be done?
"John Bell" wrote:

> Hi
> If you can export it into it's own database then a backup can be made and
> restored on the other PC.
> If the whole database is not big, then just take the whole backup. It is n
ot
> clear why you want the one table and not a whole consistent backup!
> http://support.microsoft.com/kb/304692/EN-US/
> John
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
>
>|||DTS can copy individual tables and their data to databases
on different servers.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>|||I assume DTS stands for Data Transformation Service but that still doesn't
give me a clue how to save and restore an individual table.
"Armando Prato" wrote:

> DTS can copy individual tables and their data to databases
> on different servers.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> it
> to
>
>|||Why do you need to save it and restore it? I think if worse came to worse,
you
could place it on it's on filegroup and go that route.
With DTS, you can copy the table directly and not jump through any hoops.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...[vbcol=seagreen]
> I assume DTS stands for Data Transformation Service but that still doesn't
> give me a clue how to save and restore an individual table.
> "Armando Prato" wrote:
>
restore[vbcol=seagreen]
need[vbcol=seagreen]|||Are you going to tell me how to do that with DTS or do you just want to keep
me in suspence?
I already explained why I need to save & restore?
"Armando Prato" wrote:

> Why do you need to save it and restore it? I think if worse came to worse
,
> you
> could place it on it's on filegroup and go that route.
> With DTS, you can copy the table directly and not jump through any hoops.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...
> restore
> need
>
>|||Well, you could've done a wee bit of leg work and researched DTS.
DTS is a very simple tool that can be accessed right from
the Microsoft SQL Server folder on your server. The folder
entry is called "Import and Export Data". From there a wizard
launches that asks you your source and destination servers along
with a screen that lists all available tables on the source where you check
off the
one you want to export.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:DC936A64-DF31-45CB-B560-AADE917754B7@.microsoft.com...
> Are you going to tell me how to do that with DTS or do you just want to
keep[vbcol=seagreen]
> me in suspence?
> I already explained why I need to save & restore?
> "Armando Prato" wrote:
>
worse,[vbcol=seagreen]
hoops.[vbcol=seagreen]
doesn't[vbcol=seagreen]
I[vbcol=seagreen]|||Hi
The point was that you can create a new database and copy the one table into
that. Then you backup contains the one table. You can then restore that
database and if necessary copy the table again. Alternatives would be to to
script the table and use DTS or BCP to export the data.
You may want to use a CD or USB flash device if this data/backup is bigger
than 1.44 MB.
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:CA95E845-DA13-4589-BAEC-D0B2852ED2CB@.microsoft.com...[vbcol=seagreen]
> John
> I only need one table to test with at another location.
> I want to be able to copy one table to a floppy and then restore.
> The backup option copies the whole database.
> How can this be done?
> "John Bell" wrote:
>

Saving and Restoring a SQL SERVER Table

Can anyone tell me how I can save or copy a SQL Server table and restore it
on another system?
I am running SQL Server 2000.
I see how I can export it to another database on my machine. But I need to
copy the table to another PC.
Any help is appreciated.
RonHi
If you can export it into it's own database then a backup can be made and
restored on the other PC.
If the whole database is not big, then just take the whole backup. It is not
clear why you want the one table and not a whole consistent backup!
http://support.microsoft.com/kb/304692/EN-US/
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
> it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
> to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>|||John
I only need one table to test with at another location.
I want to be able to copy one table to a floppy and then restore.
The backup option copies the whole database.
How can this be done?
"John Bell" wrote:
> Hi
> If you can export it into it's own database then a backup can be made and
> restored on the other PC.
> If the whole database is not big, then just take the whole backup. It is not
> clear why you want the one table and not a whole consistent backup!
> http://support.microsoft.com/kb/304692/EN-US/
> John
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> > Can anyone tell me how I can save or copy a SQL Server table and restore
> > it
> > on another system?
> > I am running SQL Server 2000.
> > I see how I can export it to another database on my machine. But I need
> > to
> > copy the table to another PC.
> > Any help is appreciated.
> > Ron
> >
>
>|||DTS can copy individual tables and their data to databases
on different servers.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>|||I assume DTS stands for Data Transformation Service but that still doesn't
give me a clue how to save and restore an individual table.
"Armando Prato" wrote:
> DTS can copy individual tables and their data to databases
> on different servers.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> > Can anyone tell me how I can save or copy a SQL Server table and restore
> it
> > on another system?
> > I am running SQL Server 2000.
> > I see how I can export it to another database on my machine. But I need
> to
> > copy the table to another PC.
> > Any help is appreciated.
> > Ron
> >
>
>|||Why do you need to save it and restore it? I think if worse came to worse,
you
could place it on it's on filegroup and go that route.
With DTS, you can copy the table directly and not jump through any hoops.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...
> I assume DTS stands for Data Transformation Service but that still doesn't
> give me a clue how to save and restore an individual table.
> "Armando Prato" wrote:
> >
> > DTS can copy individual tables and their data to databases
> > on different servers.
> >
> > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> > > Can anyone tell me how I can save or copy a SQL Server table and
restore
> > it
> > > on another system?
> > > I am running SQL Server 2000.
> > > I see how I can export it to another database on my machine. But I
need
> > to
> > > copy the table to another PC.
> > > Any help is appreciated.
> > > Ron
> > >
> >
> >
> >|||Are you going to tell me how to do that with DTS or do you just want to keep
me in suspence?
I already explained why I need to save & restore?
"Armando Prato" wrote:
> Why do you need to save it and restore it? I think if worse came to worse,
> you
> could place it on it's on filegroup and go that route.
> With DTS, you can copy the table directly and not jump through any hoops.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...
> > I assume DTS stands for Data Transformation Service but that still doesn't
> > give me a clue how to save and restore an individual table.
> >
> > "Armando Prato" wrote:
> >
> > >
> > > DTS can copy individual tables and their data to databases
> > > on different servers.
> > >
> > > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > > news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> > > > Can anyone tell me how I can save or copy a SQL Server table and
> restore
> > > it
> > > > on another system?
> > > > I am running SQL Server 2000.
> > > > I see how I can export it to another database on my machine. But I
> need
> > > to
> > > > copy the table to another PC.
> > > > Any help is appreciated.
> > > > Ron
> > > >
> > >
> > >
> > >
>
>|||Well, you could've done a wee bit of leg work and researched DTS.
DTS is a very simple tool that can be accessed right from
the Microsoft SQL Server folder on your server. The folder
entry is called "Import and Export Data". From there a wizard
launches that asks you your source and destination servers along
with a screen that lists all available tables on the source where you check
off the
one you want to export.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:DC936A64-DF31-45CB-B560-AADE917754B7@.microsoft.com...
> Are you going to tell me how to do that with DTS or do you just want to
keep
> me in suspence?
> I already explained why I need to save & restore?
> "Armando Prato" wrote:
> > Why do you need to save it and restore it? I think if worse came to
worse,
> > you
> > could place it on it's on filegroup and go that route.
> >
> > With DTS, you can copy the table directly and not jump through any
hoops.
> >
> > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...
> > > I assume DTS stands for Data Transformation Service but that still
doesn't
> > > give me a clue how to save and restore an individual table.
> > >
> > > "Armando Prato" wrote:
> > >
> > > >
> > > > DTS can copy individual tables and their data to databases
> > > > on different servers.
> > > >
> > > > "Ron" <Ron@.discussions.microsoft.com> wrote in message
> > > > news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> > > > > Can anyone tell me how I can save or copy a SQL Server table and
> > restore
> > > > it
> > > > > on another system?
> > > > > I am running SQL Server 2000.
> > > > > I see how I can export it to another database on my machine. But
I
> > need
> > > > to
> > > > > copy the table to another PC.
> > > > > Any help is appreciated.
> > > > > Ron
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Hi
The point was that you can create a new database and copy the one table into
that. Then you backup contains the one table. You can then restore that
database and if necessary copy the table again. Alternatives would be to to
script the table and use DTS or BCP to export the data.
You may want to use a CD or USB flash device if this data/backup is bigger
than 1.44 MB.
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:CA95E845-DA13-4589-BAEC-D0B2852ED2CB@.microsoft.com...
> John
> I only need one table to test with at another location.
> I want to be able to copy one table to a floppy and then restore.
> The backup option copies the whole database.
> How can this be done?
> "John Bell" wrote:
>> Hi
>> If you can export it into it's own database then a backup can be made
>> and
>> restored on the other PC.
>> If the whole database is not big, then just take the whole backup. It is
>> not
>> clear why you want the one table and not a whole consistent backup!
>> http://support.microsoft.com/kb/304692/EN-US/
>> John
>> "Ron" <Ron@.discussions.microsoft.com> wrote in message
>> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
>> > Can anyone tell me how I can save or copy a SQL Server table and
>> > restore
>> > it
>> > on another system?
>> > I am running SQL Server 2000.
>> > I see how I can export it to another database on my machine. But I
>> > need
>> > to
>> > copy the table to another PC.
>> > Any help is appreciated.
>> > Ron
>> >
>>

Save/Copy column mappings in DTS?

Is it possible to save column mapping definitions from a Transform Data Task? The practical use is I have four tables with very similar layouts of which 200 or so columns are identical. I have various front and back office applications that require local copies of this data in various formats. It is EXTREMELY tedious to remap all of the columns for each Transform Data Task required on these applications.

Is there a way to store all of the column mapping def's and import them into a new transform data task?if you are using SSIS, the task itself is an xml file so you could just edit it directly... :)

EDIT: did I say task? I meant the package is an xml file.|||Save the package in Visual basic File then edit it.
And you can re-create the package from the Visual basic File.|||I should have mentioned this is sql 2k I suppose. I haven't toyed with saving packages as vb scripts yet, I'll give that a go and see what sort of damage I can do.

Save table fields to a text document

Hi. Need to know how to copy all the fields (not the data) of one table to a
text document using Enterprise Manager.
Thanks, alejandro.
...you can find the id of your table in sysObjects, and then "select * from
syscolumns where id=..."
to obtain a list that you can copy and paste to a text file.
Or you can define a DTS transformation between a SQL source (select top 0 *
from TableName) and a text file destination.Than click "Properties" button
in the text file destination and check "First Row has column names" option.
Francesco Anti
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> Hi. Need to know how to copy all the fields (not the data) of one table
to a
> text document using Enterprise Manager.
> Thanks, alejandro.
|||Asked and answered in .programming -- please refrain from multi-posting.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> Hi. Need to know how to copy all the fields (not the data) of one table
to a
> text document using Enterprise Manager.
> Thanks, alejandro.
|||thats good, tnx
"Francesco Anti" wrote:

> ...you can find the id of your table in sysObjects, and then "select * from
> syscolumns where id=..."
> to obtain a list that you can copy and paste to a text file.
> Or you can define a DTS transformation between a SQL source (select top 0 *
> from TableName) and a text file destination.Than click "Properties" button
> in the text file destination and check "First Row has column names" option.
> Francesco Anti
> "alejandro" <alejandro@.discussions.microsoft.com> wrote in message
> news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> to a
>
>

Save table fields to a text document

Hi. Need to know how to copy all the fields (not the data) of one table to
a
text document using Enterprise Manager.
Thanks, alejandro....you can find the id of your table in sysObjects, and then "select * from
syscolumns where id=..."
to obtain a list that you can copy and paste to a text file.
Or you can define a DTS transformation between a SQL source (select top 0 *
from TableName) and a text file destination.Than click "Properties" button
in the text file destination and check "First Row has column names" option.
Francesco Anti
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> Hi. Need to know how to copy all the fields (not the data) of one table
to a
> text document using Enterprise Manager.
> Thanks, alejandro.|||Asked and answered in .programming -- please refrain from multi-posting.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> Hi. Need to know how to copy all the fields (not the data) of one table
to a
> text document using Enterprise Manager.
> Thanks, alejandro.|||thats good, tnx
"Francesco Anti" wrote:

> ...you can find the id of your table in sysObjects, and then "select * fr
om
> syscolumns where id=..."
> to obtain a list that you can copy and paste to a text file.
> Or you can define a DTS transformation between a SQL source (select top 0
*
> from TableName) and a text file destination.Than click "Properties" button
> in the text file destination and check "First Row has column names" option
.
> Francesco Anti
> "alejandro" <alejandro@.discussions.microsoft.com> wrote in message
> news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> to a
>
>

Save table fields to a text document

Hi. Need to know how to copy all the fields (not the data) of one table to a
text document using Enterprise Manager.
Thanks, alejandro....you can find the id of your table in sysObjects, and then "select * from
syscolumns where id=..."
to obtain a list that you can copy and paste to a text file.
Or you can define a DTS transformation between a SQL source (select top 0 *
from TableName) and a text file destination.Than click "Properties" button
in the text file destination and check "First Row has column names" option.
Francesco Anti
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> Hi. Need to know how to copy all the fields (not the data) of one table
to a
> text document using Enterprise Manager.
> Thanks, alejandro.|||Asked and answered in .programming -- please refrain from multi-posting.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> Hi. Need to know how to copy all the fields (not the data) of one table
to a
> text document using Enterprise Manager.
> Thanks, alejandro.|||thats good, tnx
"Francesco Anti" wrote:
> ...you can find the id of your table in sysObjects, and then "select * from
> syscolumns where id=..."
> to obtain a list that you can copy and paste to a text file.
> Or you can define a DTS transformation between a SQL source (select top 0 *
> from TableName) and a text file destination.Than click "Properties" button
> in the text file destination and check "First Row has column names" option.
> Francesco Anti
> "alejandro" <alejandro@.discussions.microsoft.com> wrote in message
> news:E5E25601-E0E9-4A2B-8CBB-6C4D2F92AFC8@.microsoft.com...
> > Hi. Need to know how to copy all the fields (not the data) of one table
> to a
> > text document using Enterprise Manager.
> >
> > Thanks, alejandro.
>
>

Save Report to directory

I am rendering my reports just fine from within my VB.NETapplication,
however, I need a copy of the report to be saved to a temporary directory
with the name of the report being a value from my database table...say name.
Does anyone have any idea how to do this?
--
KristinHi Kristin (& all),
I've got the same question (but have only had it since 9am this morning). I
know that it must be feasible, I'm looking into report subscriptions. My .NET
ERP system is hitting RS via a URL, so I'm also thinking of trying to clone
the ID from the querystring instead of from the DB.
Sorry I don't have anything definitive for you, just some ideas and an echo
of your question.
Cheers,
Andrew
"Kristin" wrote:
> I am rendering my reports just fine from within my VB.NETapplication,
> however, I need a copy of the report to be saved to a temporary directory
> with the name of the report being a value from my database table...say name.
> Does anyone have any idea how to do this?
> --
> Kristin

Save query results to Excel spreadsheet

When I run an existing query in Management Studio I get the expected results pane. If I try to copy and paste the results to an Excel spreadsheet I lose my column headers and formatting information. How do I save the query results to an Excel spreadsheet so that column headings and formatting info are preserved?

Thanks for any help you can offer...

I put the query in a view then export the view to excel.

Save bmp to image field

I'm trying to determine how to save a bmp into my image field. I see the
bulk copy instructions, but that is only good if you know the size of the
bmp and write it into the format file. I need to save directly into the
field from a vb6 app. Any thoughts?
ThanksI'm assuming that you are using ADO. You should use a parameterized insert
and add an adLongVarBinary parameter to your parameter collection. Then use
the AppendChunk method on the parameter to write the BMP data to the
parameter. Finally calling Execute to send the statement to the server.
I don't use ADO that often, so those instructions might need a little
revising.
Brannon Jones
Developer - MDAC
This posting is provided "as is" with no warranties and confers no rights.
"ddg1950" <dgoncher@.clearlam.com> wrote in message
news:ujaxwwK8DHA.3348@.TK2MSFTNGP09.phx.gbl...
> I'm trying to determine how to save a bmp into my image field. I see the
> bulk copy instructions, but that is only good if you know the size of the
> bmp and write it into the format file. I need to save directly into the
> field from a vb6 app. Any thoughts?
> Thanks
>