One Good Question

“How do I…?” I get questions that begin this way. Today, a friend reached out to ask how to search internals of SSIS packages deployed to an instance of the SSIS Catalog. My response was, “I don’t know, but this is how I would learn the answer.” I sent the following query: Select OBJECT_NAME(id) as …
Continue reading One Good Question

Andy Answers: Format a Flat File Name

My Twitter DMs are open @AndyLeonard. Ask me a question about SSIS, ADF, or Biml. I may answer it with a blog post, a video, or both. Today’s Andy Answer is an answer to an SSIS question received via @AndyLeonard direct message: Using SSDT, I have 3 variables: one for the file path, one for …
Continue reading Andy Answers: Format a Flat File Name