SSIS access db file transfer

  • Hello everybody,

    I and my friend need some help :

    I want to transfer a few access mdb kept in a folder to sql server. I am using foreach file enumerator. I want to perform the following actions :

    1. At time of loading the file, check if the file name starts with "ED". If not, move the file to error folder.

    2. Count no. of records that were there in the access db and that were transferred to the sql table.

    3. I also want to run the package from command line. Even though i figured out that, i want to display only limited messages on the console. For eg: File processing begins, File currently being processed, TOtal rows transferred, File processing completed etc.

    Please guide me with some examples.

    thanks lalit.

  • Hi,

    I fail to understand what does that link potray? I do not want a basic tutorial :w00t:

    If anyone else can give me some hints on solving this, i would be very glad to hear that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply