I havent extracted from Sybase yet, but have to ask the question (and shoot me if I am wayyy off track), what is your package encryption set as, and are...

But your datatype on the database is date and/or time?

Why not make your variable the same and give it a try

hey,

Package Configurations will definitely resolve your problem.

Really there isnt much to it.

You need 1 variable telling SQL where your configurations reside. This must be an environment variable.

If you choose...

Not quite sure, but I do know that I am able to load a flatfile with a normal data transformation from a Mapped Network Drive.

Just wont work so nicely with...

Is your variable type specified correctly?

I use the package deployment wizard every time without a hitch.

What version are you running??? Are you sure that you typed in the right userid and password?

Only a pleasure Srinath,

I know what its like when you are just unleashed on SSIS, you tend to scan the fine print and go for what you are after.

Many a...

Whoa!

Quite a messy script....

Without looking at that script, here is one (assuming that you use varPUI, and that varPUI is in the read/write section of your variables)

- Add a pre-execute...

Actually, took exception to the way in which the author was asking for help more than anything else, but yeah, once more, fix the problem at source

~PD

Look at the following posting:

http://www.sqljunkies.com/WebLog/sqlbi/archive/2005/05/30/15684.aspx

This will give you a fairly good idea of what needs to happen, in order for you to set a value during your transformation,...

hey Srinath,

I can recall when I updated my first variable in a scripting destination, and it was quite interesting....

First off, are you updating your variable, in your controlflow, as a...

Agreed, you do whatever it takes to get the job done.

HOWEVER, now that you have implemented, why not go back and have a look at fixing it the right way?

Post...

Briefly glanced at a couple of things:

a) Your mdb variable just needs to contain the folder name, you are confusing the wildcard with the foldername. In other words, it just...

No you cant.

SSIS only ships with Standard and Enterprise Editions

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Upgrade...

~PD

Hey,

I would suggest that you start by looking at what to convert from your ActiveX script into .NET

This is going to take you some time to do, and a whole...