DTS Protection

I'm trying to protect a package... using an owner password.
After I create an owner password and generate a dts command line from
DTSRunUI... it puts the package password in the string.
Basically if someone goes into the job and looks at this line they have the password to open the package...

DTSRun /S "svr-eqanalysis" /N "OrgExtract Rename" /M "password" /G "{2E2B6F07-0E56-4212-A894-B85A4EAA6C8C}" /W "0" /E

We can not remove the builtin administrators group from the machine
therefore system admins that want to poke around into our work can do so...
any suggestions.....

thanks,

jonathanRight click on the package, and select schedule. SQL Server automatically encrypts the whole command line for you. You may have to recover this from the job itself.|||Perfect.... !!!
thank you.....
jonathan|||Mcrowley
How would one stop a person from messing with the sql server agent... under the same circumstances...
stopping from someone changing a particular job...
more then one dba or system admin has a job
you want to secure just your job from others...
possible... ?

DTS Parsing Delimited Record

I am running SQLServer 2000 and am parsing a delimited file. Each line
is delimited with a crlf, but each line also ends with a tilda (~) that
I do not want to process. Each line does not have the same number of
elements, but every line ends with a tilda. Is there a way to set the
input file parser to strip off the tilda (that is, define the end of
line marker to be ~+cr+lf ?
Thanks,
greg lindstromhi,
why don't use each line as 'fixed field' from the beginning till the end and
then, using VbScript and substring do what you want.
--
current location: alicante (es)
"tuba_ranger" wrote:

> I am running SQLServer 2000 and am parsing a delimited file. Each line
> is delimited with a crlf, but each line also ends with a tilda (~) that
> I do not want to process. Each line does not have the same number of
> elements, but every line ends with a tilda. Is there a way to set the
> input file parser to strip off the tilda (that is, define the end of
> line marker to be ~+cr+lf ?
> Thanks,
> greg lindstrom
>

DTS Package troubles

This summary is not available. Please click here to view the post.

Dts object not visible in my DataFlow ScriptComponent

I am trying to set the TaskResult in my DataFlow ScriptComponent, but the Dts object is not visible.

Dts.TaskResult =Dts.Results.Failure

The above line works fine in my EventHandler script, but the Dts object seems to be out of scope when I try to use it from my Dataflow.

One thing I have noticed is that my DataFlow ScriptComponent inherits from 'UserComponent'

I have tried adding Microsoft.SqlServer.ScriptTask reference, but can not see it in the reference list - Strange?

Any help appreciated.

Regards,

Paul.

Try these two links I think he covered what you need but your problem could be getting your data from DLL instead of a file which makes it simple. There are 40 articles on SSIS by the same writer so spend time with his tutorials. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/3576126

http://www.databasejournal.com/features/mssql/article.php/3570991

dts import text file -- max char per line 352?

I am trying to import a text file into my table.

However, the max varchar length is automatically set to 352.

It needs to be longer. Even after manually changing it, sure enough it truncates after 352.

(We put the first 16 characters into one field, and then try to get the next 800, but it only allows 352)

Any ideas?

`LeThe VARCHAR() datatype can be up to 8000 characters long. If you need more than that, you have my condolences and you need to resort to a TEXT column instead.

I'm not sure why your data is only importing 352 characters. 255 is a common problem, where people don't reset the maximum column width supported by Query Analyzer from the default value. I don't think I've ever seen 352 as a limit.

-PatP|||Don't have answer to question but Pat, how do you modify the max column width in QA to > 255 characters ?

Cheers|||Hit Shift-Ctrl-o, click the results tab, near dead center.

-PatP|||Pat
Thx that's really cool !