Hi all

Thank you for your help Jeff. I have got that working now.

I have two tables now (one with client details) and one with the dates. There...

Hi Jeff

Thank you so much for your help and the post.

I am half way through it now 🙂

Vani

Hi

CAn you try to update the table using a SP handling diff scenarios. E.g. First Scenario check if the Username Length is less than minlength and write an update...

Hi all

Please ignore. Got it working now

Thanks

Vani

Hi

Regarding your first question - on dates - I needed to do something similar to that. So this is what I have done.

Created a table in SQL SERVER with...

Hi

Thanks for your reply. Yeah thats the idea that am working on.

Cheers

Hi

Try using an Exec SQL Task - In here - Add the line "Exec SP Name" Set Bypass Query - False

Go to the parameters tab and add the parameters in

This...

Hi

If you need to do this only in this way an option is -

import all the data into a temp table - using a procedure - you can import...

Hi

there is a process of doing this. I have been there a few times and learnt it.. Please find attached is a doc that could help you with the...

HI

You could look into using For Each Loop in SSIS but again, why would you want to complicate the process.. Is there a reason for this to done in...

Hi all

Please find attached my solution... its a long winded way but it works...

Cheers

Hi all

Sorry forgot to do that bit 🙂

Steps -

A table created in SQL Server with the rows of data imported (i.e. Name and Email Address) since there was...

Hi

Thanks for the post... A little more explanation or comment on how to create the config file might have been helpful

cheers

Hi there

I think for a novice like me this is very useful, however in the part when adding the file to configuration a comment would be quite helpful (if there...

Hi all

Never mind I got it worked out 🙂