What happens is that the flat file connection non of the columns can be altered
you can set them in other ssis packages but not in the one that you want to use and when it comes to changes the flat file complains that not a correct file is set, even though there is one set,
and when it comes to altering a flat file source it complains that it can not find the connection and the database destination can not find the meta data BUT
when it is run it works perfectly,
so what i have had to resort to is making the part of the dts package in another package and then copying it accross
Do you have delay validation on the connection or source, or are you working off line.
Some of the components don't handle these states very elegantly.
|||I do not know what you mean buy delay validation, but i am working on the server, connected to the server on the same mechine. the connection string is set to a variable that is set in a file loop, but when i remove, the variable and try it again it stil does not work...
|||on the top menu you must check that the ssis drop down is not set to offline
没有评论:
发表评论