tag:blogger.com,1999:blog-2303058199815958946.post2239131806621236521..comments2024-03-28T10:36:35.016+01:00Comments on Microsoft SQL Server Integration Services: Script Component as source 1Joost van Rossumhttp://www.blogger.com/profile/01125981589974671317noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2303058199815958946.post-43579901411811053112013-09-03T10:20:24.387+02:002013-09-03T10:20:24.387+02:00In the Script Transformation Editor window and in ...In the Script Transformation Editor window and in the Connection Managers pane rename your Connection managers to "myFile" the default name is "connection", Intellisense will not able to read "myFile" instead "connection" if you do not renamed it . If you do not want to rename it just use "this.Connections.Connection"Anonymoushttps://www.blogger.com/profile/00384846641205429858noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-65793571819587167672013-08-23T00:38:27.242+02:002013-08-23T00:38:27.242+02:00Make sure the Connection Manager type of myFile is...Make sure the Connection Manager type of myFile is FILE.<br /><br />To check whether it is known in your script type "this.Connections." and see which connection managers are available via intellisense.Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-72544156071337571272013-08-22T22:52:10.507+02:002013-08-22T22:52:10.507+02:00Hi There
I am getting this error when I using your...Hi There<br />I am getting this error when I using your code. I am pretty new to C#.<br /><br />'Connections' does not contain a definition for 'myFile' and no extension method 'myFile' accepting a first argument of type 'Connections' could be found (are you missing a using directive or an assembly reference?) <br /><br />PS : I used same myFile to connect to a CSV file<br /><br />Your help is appreciated <br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-82698343784171027762011-12-02T08:52:46.658+01:002011-12-02T08:52:46.658+01:00@Anonymous: Thanks. Sorry I don't have code fo...@Anonymous: Thanks. Sorry I don't have code for that, this is just a very basic example which people can extend for there own situations. Embedded qualifiers and separators are quite difficult, but there is also good news: <a rel="nofollow">SQL 2012</a> has solved this problem!Joost van Rossumhttps://www.blogger.com/profile/01125981589974671317noreply@blogger.comtag:blogger.com,1999:blog-2303058199815958946.post-88821028818637307012011-12-02T00:33:32.225+01:002011-12-02T00:33:32.225+01:00Good post. I think it's worth mentioning in t...Good post. I think it's worth mentioning in the article that the code will produce unexpected (and probably unwanted) results when a field value contains the separator character. Perhaps you have some code for this that you can share :)Anonymousnoreply@blogger.com