I show SSDT as installed under Visual Studio, but when I go to start a new project for my SSIS, I can't see it. MS has surely made it extremely difficult to work with this. #ssishelp@AndyLeonard (my friend please help)
Anyone had any success using the SQL Command data access mode in SSIS using an Oracle Source component? Using the Attunity connect v5.0; works fine in Table or View mode; crashes SSDT in SQL Command mode. #ssishelp
Anyone have experience configuring variables or dynamic expressions for the #PowerQuery source in #SSIS? Working fine w/fixed query string, but can't figure out how to combo PQ SSIS expression editor to dynamically change file cnxn string #ssishelp
#ssishelp#sqlhelp I just upgraded from .Net 4.5 to 4.6.2 and from SQL 2014 to SP3. Using VS2015 and upgraded C# scripts from 2008 to 2012. Now scripts throwing nasty target of invocation error, with no other logging for script component.
Looking for advise on Highly Available EDI processing solutions that can replace a product like BizTalk for x12 & HL7 file types? Looking for rapid development, flexible, and preferably cloud based. Anyone have suggestions? #SQLHelp#sqlpass#SSISHelp
#ssishelp#sqlhelp in ssis package, one task fails, and I can see it visually when I check, but how can it alert me like via email that it failed, when it failed?
Instead of looking again at it.
Use an expression set on the ToLine property inside of the Send Mail task. You can have the expression point to a variable if you want. #ssishelp#sqlhelp
#ssishelp#sqlhelp Who in my twitterverse has either experience with or ideas on how to debug C# errors in #azuredatafactory ? Trying to help a colleague getting missing assembly fails even w/a v simple "Hello World" script task.