I am in no way highly experienced in BIML. I have just used it to build some simple repeatable templates. Visual Studio works for me. Yes it is not brilliant....

If they are 30 different structured files going to 20 different structured tables then as Phil said there is no magic wand for this in SSIS.

However there is another way...

Ok,

so not sure why you need to use a script task.

I would use a send mail task. When you do that you can use a string variable for each...

Agree with Alan,

Stairways are excellent, Step by Step too.

But the best dummies style book

The 24 hour trainer shows you tasks etc in a brief quick way. Easy to consume

E

Its like like this?

Column1,Column2,Column3

1,Something

2,Sometext

I have bodged it by opening up the CSV and placing a blank space after the last comma. It seems to be comma and then end of...

Not easy but very reusable code to learn is to use C# in script task. You can then define the directory in a package variable. Then in the script task...

Looks like this is what I was thinking of

E

the XSD has just one data column in it. This is the real crux of the issue. So when I extract the data I get text and cell_id that I...

Would appreciate that

E

Does this help ?

E

Changed the account that SSAS service runs under to my account.

No change

Then looked at the advanced properties. Now the timeout was set to 15. Changed this to zero and it...

Cheers dude,

just tried that, oddly I though that was going to do it but sadly no.

Tried connecting to

(local)

Then browesd to default

Then browsed to named instance.

Same result as before.

So as...

Bizare

added a named instance and same result.

Installed VirtualBox, Win 8 and SQL 2012 and all is ok on the virtual box but not on my machine?

Any suggestions? Have googled and...

Add to that I have accidentally removed the login for the service. Not a good day at the office

🙁

I know I could pass out Flat File Source Error Output Column if the source of the Error was a flat file but it does not really point the finger...