Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.0k views
in Technique[技术] by (71.8m points)

dynamic - SSIS Connection string not dynamically changing in child package for OLE DB Source

I am using VS2019 to create a SSIS project that will include a parent package that will run multiple child packages in sequence. The main packages reads a Task table and collects a connection string and passes it to the child package to use when reading a table using an OLE DB Source. I have some debugging steps created to insure that the connection string is being passed to the package parameter properly. I have an expression setup on the Connection manager to get the parameter. I also have it set for DelayValidation = True. When I run the package the debug steps indicate that the connection string is being passed but the connection manager fails to use it. Here are some screen shots of my setup. I am looking to find a way to get the Connection manager to use the passed in Connection string.

enter image description here enter image description here enter image description here

question from:https://stackoverflow.com/questions/65946155/ssis-connection-string-not-dynamically-changing-in-child-package-for-ole-db-sour

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...