Hi Wayne

Thanks for ur help... I got it now

Cheers for your help 🙂 🙂

Hi

Depending on what type of export you need to do, there are few things.. If its a simple export then use the wizard else please post your question in...

Hi there

Well you can try the following -

Create a Template file and save it and in the package depending on what is needed copy the file over and get...

Hei

Gr8 it worked .... YAY 🙂 🙂

cheers

Vani

Hi Darren

Have you tried to change the security first back to default run it and reset it back again and check if it works...

also keep different passwords for each package...

Hi there

this may be help you out if needed...

let me know if i can help further

cheers

Hi Justin

how are you going with this

Let us know if you need help

Cheers 🙂

Hi Justin

Lets start over with the excel - Create one spreadsheet and leave the name as default

Open the connection manager in ssis - remove the setting in the expression task

and...

Hi Jeff

No worries... Am learning it myself...

Hope you enjoy learning it

Cheers

Hi Justin

How are you going...

The package i sent you should work ones you specify the database connection and the variable path...

Let me know if you need help

Cheers

Hi Justin

How did it go... is the copy of the file i sent you working

Hi ya

guess you have checked all the settings in the package and have you tried to test run package with few files in the folder and see if that happens...

Hei

how did it go... have you got it working 🙂

Hi ya

please try the below. just worked it out

Create the following variables

Filepath - Package level - type - String Path - C:\Documents and Settings\Desktop\Results

ProdName - Package Level - Type...

Hi Durani

Am not exactly aware of how to do this, but this is a thought you may want to consider.

Create a template file and copy that over every time...