You can also run the following:

select * from information_schema.columns

which will return all column information for each table in the current database

This link should give you a good example of what you are trying to do.

http://www.sqldts.com/default.aspx?246

Good Luck,

Darrell

Here is some more information on adjusting the size of the text file columns.

http://www.sqldts.com/default.aspx?297

Good Luck,

Darrell

Prabhakar,

Here is a script I am using in a DTS package:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tblBuildingAlias_tblBuildingName]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[tblBuildingAlias] DROP CONSTRAINT FK_tblBuildingAlias_tblBuildingName

just...

If the first thing you do when you pager goes off at 3:00 AM is get a Mountain Dew - you might just be a DBA!!

If you are using the "Execute Process Task" you may be running into an issue where the task was able to start the exe which results in a return code...

Suresh,

I would take a look at using DTS. Using a Transform to query the data and put it into a "text file" destination.

Good luck,

Darrell

I don't know about that Calvin,

I am not a "public" person or company, I am a "private" citizen and as such I believe my private information should stay that way!!...

Another option would be to read through the registry and locate the instance names (along with the server name). This info could then be pumped into the DTSRun command.

Good luck,

Darrell

I am just depressed because I don't have any new toys!!!

It's always fun setting up the new toy and playing, congats and enjoy!

Darrell

Erich,

when specifying the server (/S) use this syntax:

/S server_name\instance_name

Trevor,

This might help you some.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtsptasks_5r90.asp

Good luck,

Darrell

Not sure if this will help either one of you but...

This site has some execellent examples of controlling workflow through ActiveX Scripts.

http://www.sqldts.com/?103

Mark,

Try something like this:

SELECT fieldname1

FROM tablename

WHERE fieldname2 Like ('%' + ? + '%')

Then set the input parameter to your global variable and if you want you can also set the fieldname1...

Landon,

Do you have the variable @returnValue mapped to the global variable gvPTJournalID in the Output Parameter Screen? (left hand column should contain the @returnValue).