Filter
Exclude
Time range
-
Near
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)
1
3
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
2
4
4
Attn #biml heads (@AndyLeonard @Made2Mentor @cathrinew), does biml/biml script support Tabular or just mdx cubes? #sqlhelp #ssis #ssishelp
2
2
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
1
1
#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.
2
1
25 Jun 2019
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
2
1
Replying to @tjaybelt
You can set up event handlers for a specific task and create a send mail task when that step fails docs.microsoft.com/en-us/sql… #ssishelp #sqlhelp

1
2
5 Jun 2019
#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.
2
1
Replying to @tjaybelt
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
2
#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.
1
2
Trying to figure out how to take a very long array in an SSIS data flow and have each number transformed into a row. It's 3000 comma separated bigints. #SQLHelp #SSIShelp #csharpHelp? #SSISCustomComponent #SSISScriptComponent
4
1
1
What provider should be used in SSIS to connect to Oracle these days? Details: bit.ly/2qcB6SP #sqlhelp #ssishelp

1
1
2
How do you troubleshoot #SSIS out of memory issues during package execution? #ssishelp #sqlhelp
1
1
Any suggestions on how to get the #SSIS package xml from the catalog with #PowerShell stackoverflow.com/questions/… #SSIShelp #sqlhelp

I'm getting an error when I try to run my SSISDB standard reports. Any advise on how to fix? #SQLHelp #SSISHelp.
2
#ssishelp a way to data scrape XML for table names, etc?
5
Replying to @mnDBA
@mnDBA #sqlhelp #ssishelp this stands resolved. Turns out the view had a date which wasn't formatted to comply with OLEDB formatting. Thanks
1
1
Replying to @mnDBA
@mnDBA #sqlhelp #ssishelp Thanks a lot Paul. Really appreciate.
1
Replying to @mnDBA
@mnDBA #sqlhelp #ssishelp I set usersession to true. Still no good. Other views in same schema no issue whatsoever
2
1
Replying to @mnDBA
@mnDBA #sqlhelp #ssishelp Oracle provider for OLEDb
1