question

neeehar avatar image
neeehar asked

needs new metadata sas input

i have an ssis package to pull sas info into sql server. Sometimes new fields get added into sas datasets and this causes my ssis to fail.So, any ideas?
ssis
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Spizotfl avatar image
Spizotfl answered
Just saw a presentation last week about using BIML and Powershell that you might be able to leverage to meet your needs. Here's a link to the BIML stairway: [link text][1] [1]: http://www.sqlservercentral.com/stairway/100550/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

neeehar avatar image neeehar commented ·
Thank you
0 Likes 0 ·
neeehar avatar image
neeehar answered
BIML offers a solution but my client doesn't allow me to install the software. Any other solutions?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.